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

crossword

New member
Joined
Jun 26, 2013
Messages
10
Reaction score
0
Points
0
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
 
Do you mean .... Conditional formatting formula for C2 down......

=AND($C2=TODAY(),$B2="Call Back")
 
If the Call Back date is 3 days later -
DateCall Status1Call Back Date
2/2/2014Call Back5/2/2014
So, on that date the color should change ....
 
Did you try my suggestion? It should work.
 
Back
Top