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

**crossword** · 2014-02-07, 08:02 AM

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

**NBVC** · 2014-02-07, 02:48 PM

Do you mean .... Conditional formatting formula for C2 down......

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

**crossword** · 2014-02-10, 06:26 AM

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 ....

**NBVC** · 2014-02-10, 08:58 PM

Did you try my suggestion? It should work.

**crossword** · 2014-02-11, 06:07 AM

Thanks sir

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