View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default formula to remind me of an appointment 3 months in the future

Hi jamaican,

One way

In cell A1 put =TODAY()
In cell B1 put Your target date
In cell C1 put =B1-A1

Then use conditional formatting in C1 to fill the cell Red
when cell value is equal to zero.

When you open the file each morning any meetings due that
day will be red. If you aren't going to open it each day it
may be safer to use cell value is less than or equal to zero.

You can come up with a lot of other variations along similar lines.

HTH
Martin