Hello,

I need help writing the VBA code to acomplish the
following: I need to find any date in a spreadsheet that
is <= 90 days old; then I want to change the back color of
the row to yellow for those dates. For example if I had
the following data:
Name Acct# AcctCloseDate
This Guy 123456 01/01/2004
That Guy 654321 10/15/2004
Since the first date is over 10 months old (way past 90
days) I would leave the row as it is. Since the second
date is only 6 days old I would want to change the whole
row or at least the cell contaning that date to yellow.
Any help with a solution will be greatly appreciated.
Thank you.

Dave Y