I need a macro that will search entire worksheet and if a date is listed, check that date and do the following:
1. If the date is greater then 60 days from todays date, do nothing.
2. If the date is less then 60 days from todays date, change the cell color to yellow.
3. If the date is less then 30 days from todays date, change the cell color to orange.
4. If the date is equal to or older then todays date, change the cell color to red.

Help!