Condition formatting & Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Skippy - 13 Sep 2007 01:28 GMT

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

Reply to this Message

Pete_UK - 13 Sep 2007 01:34 GMT

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

> Hi
>
[quoted text clipped - 7 lines]
>
> many thanks

Reply to this Message

Skippy - 13 Sep 2007 02:16 GMT

Thanks Pete, all good now.

> Hi
>
[quoted text clipped - 7 lines]
>
> many thanks

Reply to this Message

Pete_UK - 14 Sep 2007 00:54 GMT

Glad it worked - thanks for feeding back.

Pete

> Thanks Pete, all good now.
>
[quoted text clipped - 11 lines]
>
> - Show quoted text -

Reply to this Message