Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?