To highlight dates 1 year old (to the day) or older use this formul
with conditional formatting "formula is" option.
=DATEDIF(A1,TODAY(),"y")
If you have blank cells in your range you might also wish to adapt tha
to prevent blanks being highlighted so use
=(A1<>"")*DATEDIF(A1,TODAY(),"y"
