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

[crossword]

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]

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

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

[crossword]

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]

Did you try my suggestion? It should work.

[crossword]

Thanks sir