How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

rollis13 · #9 07-29-2022, 08:53 AM

So where you messed up was in post #4 where you asked about the grades "ABC" which is text. In column C you have numbers 123 so the formula in CF cannot be C6="1" but must be C6=1 .
If you use double quotation marks it goes without saying that you are dealing with text and as you well know in Excel "1" (text format) is not equal to 1 (decimal format).
I leave you the task of fixing the whole formula

.

PS. forgot about when J6 has a date, does it still need be highlighted if over date ?
If so then the formula in CF could be:

=AND(J6="",OR(AND(C6=1,TODAY()-I6>30),AND(C6=2,TODAY()-I6>15),AND(C6=3,TODAY()-I6>7)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for looking at 1 cell with a date and then comparing it to four date ranges	LearningMom	Excel	3	10-27-2017 12:44 PM
Need help with using traffic lights in one cell based on date value in a different cell	wmedjaxnjr	Excel	1	04-09-2016 04:22 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM