If a cell say B2 holds the Completion Date how can it also display Check Me?
How about using a Conditional Format to make the Completion Date cell go red
if its value is with in 3 days of the current date?
Let us know it this would help.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ADB-NewB" wrote in message
...
Is there a way to set an alarm in a cell using the If formula example?
(Check
me) when a Tentative date needs to be completed by
Exp: if the tentative date is getting near the completion date I would
like
the completion date cell to read (Check Me) can it be based of an empty
cell
Date Received Completed Date Completed By Tentative date
10/31/2007 11/14/2007
Say for example (cellA1="", Check Me) ???? then what

Please help..Thanks in advance