Assume that you are having the Date Values in A Column. Place the cursor in
A1 cell and press Cntrll+Spacebar and now the total A Column will be getting
selected. A1 should be the active cell (Active Cell will have a white
Background after selection also).
Excel 2003:-
Select Format>>Conditional Formatting>>Condition 1>>Formula Is>>
=AND($A1<>"",DATEDIF($A1,TODAY(),"Y")>=3)
Then Click the Format command button and choose your desired Font and
Pattern colour and give Ok…
Excel 2007:-
Click Home>>Conditional Formatting>>Manage Rules
OR
Alt+O+D
Click New Rule>>Select Use Formula to determine which cell to Format>>Format
Values Where This Formula is True>> Copy and paste the below formula
=AND($A1<>"",DATEDIF($A1,TODAY(),"Y")>=3)
Click Ok>>Apply>>Ok.
Remember to Click Yes, if this post helps!