Reset the formula

[murrey]

If the tickler must go in effect from the 45th day on, use:

=IF(TODAY()-B2<=45,"Time To Call","")

But then, how do I reset the formula when I put in a new date for another 45 days? Thanks so much

 

[Brian from Maui]

Change the date in B2 or reference another cell with the date in it.

 

[Aladin Akyurek]

On 2002-05-01 12:23, Brian from Maui wrote:
Change the date in B2 or reference another cell with the date in it.

Brian,

I think Murrey is registering every date when a call event occurs.

The (modified) formula should better refer to the latest call date.

Aladin
This message was edited by Aladin Akyurek on 2002-05-01 12:29

 

[murrey]

If I put in the latest date, the next cell with "Time To Call" doesn't go away like I want it to ---

 

[murrey]

And what do I add in the formula to make the cell turn yellow or green when "Time To Call" pops up in 45 days?
Thanks so much.

 

[kinkyparamour]

Highlite the cells you want to change. Go to format/conditioal formting. Chose cell value is, in the next window chose equal to, in the next window type "time to call". Now click on format and chose a color. You may want to consider changeing the font color instead of the cell color.............


Denny
This message was edited by kinkyparamour on 2002-05-01 14:04