excel conditional formatting

Hello, I try to use conditional formatting for data I grabbed via an external method from my DLL. I've done this with single or even multiple columns quite often, works always as expected. No fancy stuff just using Color Scales from the menu. Suddenly with one spilled area it doesn't work. I've...

I have been down the rabbit hole for the past few hours on this one... Here is my predicament. I have a spreadsheet the Signs In/Out individuals via barcode scanner (Macro underneath to population times in columns to the right of name). The users of this spreadsheet would like for the name of...

I am trying to create a formula that will turn a cell yellow if today's date falls between two dates and red if today's date falls later than another date. I'm not even sure if this formula exists. Example: We want the cell to turn yellow if today's date is between 8/1/2023 and 9/30/2023. We...

I need conditional formatting for rental increases that are 1) highlight the date for notices that are less than 30 days away and 2) once the notice is sent, to remove the highlight (See the attached image). These need to apply to the entire column. I have a conditional formatting for column C...

'Good afternoon all, I'm looking to conditionally format the below pivot table based on 0s on consecutive dates for each person. One consecutive '0', I want highlighted in pink, if it is 2nd consecutive '0' highlighted in red, and 3rd consecutive '0' or more, highlighted in a darker red. Also...

Looking to use conditional formatting to highlight a cell when I overwrite a formula in the cell and hardcode a value I enter a data value in A2 e.g. a product name , it recognizes that value as a match in a table and uses it in returning values in cells B2, C2 etc per lookup formulas in those...

I'm trying to conditionally format a row based on if the time in column R exceeds an hour. I calculated column R with formula M2-P2 but M and P are two columns with time in different formats. The calculated times in column R appear correct but aren't formatting correctly based on my conditional...

Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........

I have excel sheet where i am fetching stock market data, now it changes colour according to my conditional formatting rules, I want to know how many times in total colour has been changed in 1 particular data range during whole day here below mentioned conditional formatting rule and range is...

I have excel sheet, which has value stored as price in "D" column now, I want to highlight particular cell in column "D" which satisfies below 2 conditions XFB9<=0.02 which cell has highest value among cells that has fulfilled above condition (column "D") issue I find here in writing formula...

In air traffic control and I am making an aircraft log with aircraft's callsigns, type aircraft, departure times, arrival times etc. When working with times dealing with military aircraft, all times are in UTC time. NO local times ex. 9:00 P.M/21:00L more like 02:00 the next Julian date...

look A1 = PO12503 A20 = PO12503 Same number . ... Kindly Lock Cell Automatic ( Or not change value, Delete & modify) How Can possible this thinks , i try to Fix NUMBER, because product item file item name & product number required match.......... i have make product packing list...

Hello! I have a mega forecast that people update and I'd like to make it simple to see which cells have been updated (could be added as a new line or info deleted or changed in a cell). The model already has lots of conditional formatting indicating various things so it needs to work on-top of...

With VBA is it possible to highlight a row referring a cell in a column having multiple week number in format "W**". for example: column R in below case will have W01, W03 .... I need to highlight only those particular cells. I am stuck with the below format. With Cells...

Hello, I have a large spreadsheet that I use to find patients that have had a procedure outside of their admission and discharge dates. The spreadsheet has worked perfectly until 1/1/2020. The conditional formatting formula I am using is: Cell Value ---> not between ---> J7 --->...

Dear Sir, I have some data in Excel Sheet as per following details In Column A :- Sr.No. In Column B :- Code No. of various Institutes (e.g. 1802, 1381, 1586, 1324, 3353, 2832, 5421, 1216 etc) Each code repeats number of time in column B In Column C :- Question Paper Code of various Subjects...

We run a real estate business and each transaction is a tab in a workbook. There are a few hundred built up over the years and the file is getting too large. We would like to move older ones to an Archive Workbook for that year. It's painfully slow. I am pretty sure the conditional formatting...