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

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

--
Rick (MVP - Excel)


"Rick1" wrote in message
...
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.