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

rollis13 · #1 07-27-2022, 03:52 PM

This could be your formula for cell B" with Conditional Formatting with red fill:

=IF(AND(B2=""),TODAY()-A2>30)

Daronovitz · #2 07-28-2022, 05:30 AM

That worked! Thanks a lot I really appreciate it!

Daronovitz · #3 07-28-2022, 05:34 AM

To take it one step further: Cells A2:A6 contain dates. Cells C2:C6 have letter grades (A, B, or C) I want Cells B2:B6 to be highlighted red if nothing is entered in to those cells after 30 days if they're an A, or 15 days if they're a B, or 7 days if they're a C. How do I do that?

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