Condition formatting & Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top