|You will need to use Conditional Formatting to get it Red.|
With your three year old date in cell A1:
Conditional Formatting 2007
1) Select your cell A1
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:
6) Click on the Format button
7) Select the Fill Tab
8) Select a RED color
9) Click OK
10) Click OK
If your date in cell A1 is equal to or greater than 3 years old, it should turn Red.