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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Do you mean .... Conditional formatting formula for C2 down......

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

crossword

New member
Joined
Jun 26, 2013
Messages
10
Reaction score
0
Points
0
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 ....
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Did you try my suggestion? It should work.
 
Top