Conditional formatting on Date

[Rick1]

I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

 

[Sean Timmons]

in Conditional formatting, formula is

=cell<=now()-365

 

[Rick Rothstein]

Select "Formula Is" and use this conditional formula...

=DATEDIF(A1,NOW(),"y")>0

 

[Rick Rothstein]

That could give an incorrect result in a leap year.

 

[Rick Rothstein]

I used A1 in my formula, but you should use your actual cell address
instead.

 

[Rick1]

Perfect! Thanks for your help guys!!

I used A1 in my formula, but you should use your actual cell address
instead.