Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Reset the formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,060
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    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 ]

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •