Conditional Formatting

  • Thread starter Thread starter bettyh
  • Start date Start date
B

bettyh

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.
 
With cell A1

Condition1:
"Formula is"
=ISNUMBER(B1)
Set formatting to fill blue

Condition2:
"Cell value is equal to":
"yes"
Set formatting to yellow fill

Condition3:
"Cell value is equal to":
"no"
Set formatting to grey fill
 
THANK YOU! works like a dream.

Luke M said:
With cell A1

Condition1:
"Formula is"
=ISNUMBER(B1)
Set formatting to fill blue

Condition2:
"Cell value is equal to":
"yes"
Set formatting to yellow fill

Condition3:
"Cell value is equal to":
"no"
Set formatting to grey fill
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Back
Top