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

Daronovitz · #8 07-29-2022, 08:26 AM

You're right, I apologize for my vagueness. I see how it works on your example sheet but I cannot duplicate the efforts on my own. I can copy and paste your formula to do exactly what you did but when I try to apply it elsewhere by changing just the simple data I fail. Please see attached sheet.

I am trying to get column J to fill red when a date is not entered 30 days after column I if it has a 1 in column C, 15 days if it has a 2 in column C, and 7 days if it has a 3 in column C. Please see my conditional formatting to see where I am messing it up.

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