If Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I'm not exactly sure what you are trying to do, but if you want a cell to
read "Check Me" when the tentative date is, say, 7 days away use the
following:

=IF(B4-NOW()<=7,"Check Me","")
 
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
 
Back
Top