![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]()
This could be your formula for cell B" with Conditional Formatting with red fill:
=IF(AND(B2=""),TODAY()-A2>30) |
#2
|
|||
|
|||
![]()
That worked! Thanks a lot I really appreciate it!
|
#3
|
|||
|
|||
![]()
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?
|
![]() |
Tags |
conditional formatting, formula, rules failing |
|
![]() |
||||
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 |
![]() |
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 |