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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Macro to set Reminder on a Contact tomorro 9:00 4
send reminder email through outlook based on info from a csv/excel file 0
Import 4 Different Excel Files from One Folder 0
Excel Worksheet_BeforeDelete code not working as expected. 1
Outlook Outlook 2010: Reminders in a calendar of a public folder 0
Excel Message box with days of month & date. 1
MS Access setting outlook reminders from a DAO recordset 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top