Reset the formula

murrey · May 1st, 2002, 01:09 PM

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 · May 1st, 2002, 01:23 PM

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

Aladin Akyurek · May 1st, 2002, 01:29 PM

Quote:

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 · May 1st, 2002, 02:43 PM

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

murrey · May 1st, 2002, 02:47 PM

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 · May 1st, 2002, 03:03 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 01:09 PM	#1
murrey New Member Join Date: Apr 2002 Posts: 15	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

May 1st, 2002, 01:23 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Change the date in B2 or reference another cell with the date in it.

May 1st, 2002, 02:43 PM	#4
murrey New Member Join Date: Apr 2002 Posts: 15	If I put in the latest date, the next cell with "Time To Call" doesn't go away like I want it to ---

May 1st, 2002, 02:47 PM	#5
murrey New Member Join Date: Apr 2002 Posts: 15	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.

May 1st, 2002, 03:03 PM	#6
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	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 ]