Conditional Formatting Dates

[Frogggg]

I know there are quite a few conditional formatting posts. I have been through a few of them and I can't make it work properly.

In column D I have a list of dates that was the day a document was approved. This document needs reviewing every three years. What formula do I use if I want the date to turn red if the date in column d is more than 3 years ago?

 

[pedro-egoli]

This will need choosing 3 colours and 3 conditions
Condition 1
AND(D1<=TODAY()-365,E1="high")
Condition 2
AND(D1<TODAY()-1095,E1="low")
Condition 3
AND(D1<TODAY()-1095,E1="Moderate")

Not fully tested.
3 colours for 3 different conditions may not suit but it well may

Pedro

 

[Frogggg]

Thanks Pedro I have this one working now. Your help is appreciated.