Condition formatting & Formulas
 

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

Condition formatting & Formulas
 

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

On Sep 13, 1:28 am, Skippy wrote:
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

Condition formatting & Formulas
 

Thanks Pete, all good now.

"Skippy" wrote:

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

Condition formatting & Formulas
 

Glad it worked - thanks for feeding back.

Pete

On Sep 13, 2:16 am, Skippy wrote:
Thanks Pete, all good now.



"Skippy" wrote:
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- Hide quoted text -

- Show quoted text -