|If all you want to do is color the cell or cells |
on or after your date has reached 3 years
I'm using 2007, so you may need to adjust these instructions for 2003:
With your Issue Date in cell A1
Select cell or range of cells
On the Task Bar
Select Format - Conditional Formatting
On the first dropdown, choose Formula Is
For the formula, enter:
Click the Format button.
Select a pretty font colour .
What the formula does is simply adds three years to your issue date in cell A1 and compares it to todays date.
See how that works.