Excel XP I have 2 columns First in A1 formatted to yellow fill if the
value is "yes" and grey if value is "no" I have that done. No Problem
Cell B1 is set to fill grey if the value of A1 is "no" and blue if A1 is
"yes" Have that done, no problem.
Now, I want to add a condition to A1 that will change the formatting to fill
in blue if there is a date (any date) in B1.

Goal is to highlight follow up tasks, then, when done create a blue fill to
be able to easily follow a trail of tasks done in the spreadsheet wich notes
all client contact whether it needs follow up or not.