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.

FormatConditional FormattingFormula 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

On Tue, 11 Sep 2007 09:06:09 -0700, Martha
wrote:

I need to have some type of reminder from dates that I have listed in an
excel spreadsheet.