|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
07-27-2022, 12:47 PM
|
|||
|
|||
How do i highlight a cell red if no date has been entered 30 days after a date in another cell??
Example: Cell A2 contains the date 6/1/22. I want Cell B2 to be highlighted red if nothing is entered in to cell B2 after 30 days. How do I do it?
|
| Tags |
| conditional formatting, formula, rules failing |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2019
Threaded Mode