View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Trevor Trevor is offline
external usenet poster
 
Posts: 31
Default How do I create a prompt box?

Im trying to create promote box in excel to show that 3 months before the
expiry date. To say that €ś3 months before expiry consider for renewing€ť.

Then a day before expiry €ś1 day before pass expiries€ť

And after the expiry date €śNeed reviewing€ť

Column C2:C90 €“ are were the dates are stored and need to do a promote box
with these 3 conditions.
And would like to have a promote box appear with the name and expiry showing
or even to colour the cell when 3 month before, 1 day before and after the
expiry date