conditional formatting using dates

[creynolds]

How do I use conditional formatting using dates over 1 year old

[daddylonglegs]

To highlight dates 1 year old (to the day) or older use this formula with conditional formatting "formula is" option.

=DATEDIF(A1,TODAY(),"y")

If you have blank cells in your range you might also wish to adapt that to prevent blanks being highlighted so use

=(A1<>"")*DATEDIF(A1,TODAY(),"y")