Conditional Formating For a Date

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks
 
Use the following formula in FORMULA is
=(A1-Today())>730

assuming your dates are in Col A
 
Will this still work even if they are not todays dates. Some of these dates
go back a yaer or so.
 
Yes. Today() gives you the today's date and then compares it with the date in
A1

NOTE: I gave you the wrong direction.
Pl. use
=(Today() - A1)>730

Use 731 Iinstead of 730) if you want to take care of leap year...
 
Back
Top