Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
condition formatting with formula | Excel Worksheet Functions | |||
Custom Formatting: Can I set up a condition? | Excel Worksheet Functions | |||
Formulas to highlight cell if condition is met | Excel Discussion (Misc queries) | |||
HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
IF Function with formatting condition | Excel Worksheet Functions |