Hi Teeny

Select your range of dataFormatConditional Formattingform dropdown
choose Formula is =DATEDIF(A1,TODAY(),"y")=3
Choose Red Font

Change A1 to the appropriate reference for the range of data you choose
--
Regards
Roger Govier

Teeny wrote:
I have a column of dates and I want to highlight in red all dates that are
equal to and more than 3 years old

For example if the date is 02/10/04 this should be highlighted in red.

I would appriciate anyones help!