View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PK PK is offline
external usenet poster
 
Posts: 69
Default Automatic alerts in excel

I am trying to create a data base for training. I would like to place a date
for which some one attended a course in cell C3 and then when a refresher is
required the date of for which the qualfication is due to expire will appear
in cell F3. however I would like the cell to remain blac until 3 months
before it is due.

E.G.
Cell C3 contains 25 March 07 and the qualification required a yearley
refresher. Therefore in December 07 I would like the date 25 March 08 to
appear reminding me a refresher course is due.

When the date passes if the due date passes I would then like the words
OVERDUE to appear.

I did get some usefull advice however I cant seem to get it to work.
Thank you