View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davio davio is offline
external usenet poster
 
Posts: 3
Default Can i set a cell to alarm if a date isnt enterd before a set date

I would like to be able to alarm the fact that a date has not been entered
into the cell before a set date. IE: We sent a Drawing for approval on
10-nov-07. This is placed in cell H-7. We expect to see a reply by 15-nov-07.
Can i use a fromula to alert me if this date is not inserted into cell H-8?