Hi

Check out Conditional formatting.

Cond. form. together with dates has been dealt with many times in the
earlier newsgroup postings, so you can use the search function and you will
surely find your solution. If not, please ask further.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"mtnmanus" wrote:

I have a spreadsheet with due dates and current date - I want to change the
status on those tasks based on calculation of due date against current date.
If due date has passed - I want to turn cell "red", if not passed thenn
"green" if same day then "yellow".
How can I do this?
thanks !