You can use conditional formatting.
Assuming your date cell in A1. Go to Menu-Click Format- Conditional
Formatting
Click formula is, and paste the formula into it. Then, go to format and
format the way you want it, eg. go to the pattern tab to change the cell
colour.
=AND(DAY(TODAY())=DAY(A1),MONTH(TODAY())-MONTH(A1)=3,TODAY()-A1=90)
If you have multiple cells, select all the cells by clicking on A1 then
shift click the rest. Make sure A1 is selected, then conditional format
it by putting in the same formula.
The conditions above should be accurate enough to take care of most
conditions. Enjoy.
--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile:
http://www.excelforum.com/member.php...o&userid=34322
View this thread:
http://www.excelforum.com/showthread...hreadid=550750