View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Setting a reminder or alarm in Excel

Without knowing what you want to do it's hard to know what to suggest.

You could use a conditional format to change the background color to
something if the date is within a specific range

Format - Conditional Format
Formula is =A1 - today() < = 30

And set the format to something different.

Cell format would change if cell a1 is 30 or less days after today.

--
HTH,
Barb Reinhardt



"wysi" wrote:

Hi

I am trying to set reminders (several reminders into one spread sheet but in
different cells). Am using Excel 2000.

The reminders need to be able to show dates up to one year in advance, and
stay visible when excel is opened (several times).

Have trawled through ms help and cant find anything would be grateful for
any advice

wysi