is there any way to have a type of reminder set up from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have some type of reminder from dates that I have listed in an
excel spreadsheet.
 
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
 
Back
Top