Results 1 to 5 of 5

Thread: IF and AND Formula for a Call Back Reminder with Conditional Formatting

  1. #1

    IF and AND Formula for a Call Back Reminder with Conditional Formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Date Call Status1 Call Back Date
    2/2/2014 Call Back Formula with Conditional Formatting

    On the day of the Call Back - the Colour of the Cell should Change.

    Kindy assist

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Do you mean .... Conditional formatting formula for C2 down......

    =AND($C2=TODAY(),$B2="Call Back")


  3. #3
    If the Call Back date is 3 days later -
    Date Call Status1 Call Back Date
    2/2/2014 Call Back 5/2/2014
    So, on that date the color should change ....

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Did you try my suggestion? It should work.


  5. #5
    Thanks sir

Posting Permissions

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