![]() |
|
#1
|
|||
|
|||
![]()
SOLUTION: =$N5<=DATE(YEAR($C$2-3),MONTH($C$2),DAY($C$2)). The "-3" is interpreted as days in the YEAR expression. If "-3" is replaced with "1097", the formula works.
|
![]() |
Tags |
conditional formatting |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting/If Statement with Dates | AndrewEnos | Excel | 2 | 07-22-2014 07:34 AM |
Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
![]() |
namedujour | Excel | 1 | 06-27-2014 04:16 PM |
Conditional Formatting with Dates | namedujour | Excel | 1 | 02-21-2013 03:42 AM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |