#1
|
|||
|
|||
Date Conditional Formatting
I would like to highlight in colour a date that is within 30 days of todays date in the future.
Example - today is 17/11/2022 - therefore all dates that are between 17/11/2022 and 17/12/2022 should be in colour. Thanks Mark |
#2
|
||||
|
||||
Try =AND($A1>=TODAY(),$A1<=TODAY()+30) as CF
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Conditional Formatting | stu_c | Excel | 4 | 05-22-2022 12:39 AM |
Conditional formatting a row based on date | cwkotch | Excel | 1 | 08-28-2021 10:14 PM |
Conditional Formatting based on date | teza2k06 | Excel | 2 | 11-27-2018 09:55 AM |
Conditional Formatting based on dynamic Date | Modifier1000 | Excel | 2 | 09-12-2014 08:53 AM |
Date Conditional Formatting | teza2k06 | Excel | 1 | 08-09-2014 09:58 AM |