You could use Conditional Formatting to color cells when they approach or reach
a designated date.
Select a cell with the date entered, say 10 days from now.
Format>Conditional Formatting>Formula is:
=cellref=TODAY()+7
Format to a color of your choice.
The cell will turn color 7 days prior as a reminder that you have only one week
to go before your deadline.
You can use an orange condition at 7 days and a second red condition when you
get closer to the date.
Gord Dibben MS Excel MVP
