![]() |
#6
|
||||
|
||||
![]()
Typo of mine it shoud be YEAR($C$2)-3 . Sorry about the mistake
__________________
Using O365 v2503 - 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 |
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 |
Conditional Formatting - past due dates | namedujour | Excel | 1 | 06-27-2014 04:16 PM |
![]() |
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 |