Conditional Formating For a Date

[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

 

[Sheeloo]

Use the following formula in FORMULA is
=(A1-Today())>730

assuming your dates are in Col A

 

[Dan]

Will this still work even if they are not todays dates. Some of these dates
go back a yaer or so.

 

[Sheeloo]

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...