Condition formatting & Formulas

[Guest]

Hi

I'm using condition formatting with the following conditions:
**Change cell $K1 to Blue if the content equal 'Extension' (working fine).
**Change the entire row to No Fill when cell $A1 equals "C"

However cell $K1 which remains blue when the condition 2 should be in effect.

How can I get $K1 to change to No Fill when condition 2 is met?

many thanks

 

[Pete_UK]

There is a priority associated with conditional formatting criteria -
the first criterion takes priority over the others. Just change the
order of your criteria so that:

**Change the entire row to No Fill when cell $A1 equals "C"

is the first and thus takes priority.

Hope this helps.

Pete

 

[Guest]

Thanks Pete, all good now.

 

[Pete_UK]

Glad it worked - thanks for feeding back.

Pete

Thanks Pete, all good now.









- Show quoted text -