conditional formatting

How do I put the above into a working formula in 365? 'C' is Start of ETA 'D' is End of ETA 'E' is arrival time I need anything that isn't within the date range in C & D to flag red For example, Row 2 is 30 minutes out so is not compliant within given ETA Row 4 is net day so also not...

So, I have a workbook of jobs that have 'Job start' and 'Job Finish' values as part of it - For this example, lets say 'Job Start' is column C, and 'Job End' is column D - Both have Date and Time in each cell. I need the cells in column D to turn red if the data is over 2 days from that in...

Hi. I have posted something similar before but have yet to make my code work a 100% yet. MOST OF THE CODE WORKING! I put in a lot of code so just want to mention most are working but the addition have not been working as indented. I have a large worksheet in which there is a few macros...

Hi Everyone, I'm not trying to do anything 2 complex - just compare 2 dates (due date, last completed date), and highlight everything that is equal to or overdue for calibration. I'm using the formula =AND(isnumber($K2),IsNumber($L2),$L2<=$K2 Unfortunately, its highlighting the cell ABOVE the...

HI I hope you can help, I have been looking online and either I dont have the feature or i cannot do it. I have a table Column B to F and I want to hide the row if column F shows the word Completed. I have looked at conditional formatting but cannot find how to hide, not even sure where to...

I have read no less than 50+ help articles, watched at least that many tutorials and scrubbed the posts here for any insights, but can't seem to find precisely what I am looking for. I have a spreadsheet tracking issues/tasks (range A7:AZ1005). In cell $Q$1 the user can enter a word to search...

Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Ex.02: Red Box On the 13th, Indiana submitted two records (5hrs and 3hrs) totaling 8hrs. So their dispatcher...

Afternoon everyone... I am having a right mare with my conditional formatting formula and i feel like I've tried every variation and I've given up now... I have a list of master codes in one sheet "EWC List" I then input incoming loads in another sheet "Stock" if while i'm inputting the EWC...

Hi hopefully somebody can help. Using Conditional Formatting I've built a workbook which checks for a number in a series of columns on one worksheet and if it finds a it in a grid (named range 'Grid'), formats the cell to a particular colour. This works great, but I have 150 CFs so the whole...

Hello, New to this site so apologies if this has been covered before and I just don't know how to search for the answer. I want to use conditional formatting to make blank cells yellow in any/all columns if there is text in column A. For example, column A could be order numbers, column B could...

Hi Team, I am creating a calendar view to show room bookings and have been able to pull through the start and end time of the event, I now just want to show the cells in between as highlighted. As you can see below, the Investor Event starts at 8 and finishes at 17:30, I would like the cells in...

Hello! I am trying to write a conditional format where if the difference between the dates (H2-G2) is: <=180 days, the date in the G column turns green >180 days, the date in the G column turns red I don't want the "I" column, I was only using that column to help check/compare with whatever...

Good afternoon, I am trying to determine how to conditionally format a column of cells that will already show red when overdue. However, I want it to turn green once data is inputted to column G. I have attached the document for ease of use. So say E3 shows red because they have been enrolled...

I have the following formula that works fine to either give me a result or leave a cell blank if the value is zero...

I am trying to figure out formulas to create conditional formatting for dates that take into account the current date and its relation to future dates, and that are not limited to specific months, years, or number of days. I would like these formulas to be able to carry over into future years...

Hi I have dates in two diff columns, and need to highlight when the date in J is bigger than the one in D, of that same row And i can get the conditional formatting to work on that one row, but how do i apply it to allll rows of the document, so that its alwasys looking at the matching row so...

Hello everyone! I implore your help. I have a diet log for an office and looks like below. Now there's conditional Formatting to change the colors of the cells according to min and max values i had in column T. (calories, protein, sleep, water, steps, etc) Now the problem is that they need it...

Hello, I was hoping the community can help me. I downloaded a standard Gantt template form Excel and have begun modifying it. I would like to present 3 months of data side by side in the same worksheet (only two shown in the images). The challenge I have is that I can't seem to replicate the...

I have an excel "database" that does various calculations, data collecting and reports for an event that occurs every year. Various reports are generated from specific columns using the indirect function. My question, with the below example, is when I chose 2023, the company names Target and...

So, I have made a what we call "job List" at work. This needs to be updated every month and shows, the next 12 months, with a proposed end date for each project we are doing. It needs to be visual like a bar graph and I wasn't sure on the best way to do this whilst making it time efficient to...