Do you mean .... Conditional formatting formula for C2 down......
=AND($C2=TODAY(),$B2="Call Back")
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 -
So, on that date the color should change ....
Date Call Status1 Call Back Date 2/2/2014 Call Back 5/2/2014
Did you try my suggestion? It should work.
Thanks sir![]()
Bookmarks