Try setting the condition to
Cell Value is
Not Between
=TODAY()
=TODAY()-(365*3)

"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!