![]() |
#4
|
|||
|
|||
![]() Quote:
the 4 conditional format formulas may be =(DATE(YEAR(B4) + B$2, MONTH(B4)-12, DAY(B4))<TODAY()) =(DATE(YEAR(B4) + B$2, MONTH(B4)-6, DAY(B4))<TODAY()) =(DATE(YEAR(B4) + B$2, MONTH(B4)-3, DAY(B4))<TODAY()) =(DATE(YEAR(B4) + B$2, MONTH(B4)-1, DAY(B4))<TODAY()) (And you have to combine the order of formulas, and StopIfTrue, to get right colors used) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
![]() |
Modifier1000 | Excel | 2 | 09-12-2014 08:53 AM |
![]() |
teza2k06 | Excel | 1 | 08-09-2014 09:58 AM |
![]() |
Cosmo | Excel | 2 | 04-08-2013 12:12 PM |