Can anyone tell me how I can go about setting up a formula in excel 2003 for
the following:

In my action plan spreadsheet 2 of the columns are a due date column & a
status column. I am trying to get cells in the status column (which has a
drop down list of items to select from) to automatically change to OVERDUE
when the due date is reached. These 2 columns are next to each other. Can
this be done?

Also, I would love once a cell in the status column reads OVERDUE for that
row to be highlighted in red. Is that asking too much???

Any help would be greatly appreciated!

Thanks
Kate