Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 conditions using conditional formatting
I would like a cell to change colour for 2 separate condidtions. Cell C1 is
default cell colour grey. 1st condition is Cell C1 to change to white if A1 = "No". 2nd condition is C1 to change to yellow if A1 = "No" and B1 = "3rd Party". I have tried putting these in as 2 separate formulae in the Conditional Formatting but only condition 1 works ie C1 stays white even when "3rd Party" is in cell B1. Any help appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 conditions using conditional formatting
this is a logic problem. here is the truth table for your problem
Cell A1 No Yes No 3rd Party White Grey B1 3rd Party Yellow Grey You nee three forula in conditional formating 1) grey if A1 = Yes 2) White if A1= No and 3rd Party = No 3) Yellow is A1 = No and 3rd Party = yes "jimar" wrote: I would like a cell to change colour for 2 separate condidtions. Cell C1 is default cell colour grey. 1st condition is Cell C1 to change to white if A1 = "No". 2nd condition is C1 to change to yellow if A1 = "No" and B1 = "3rd Party". I have tried putting these in as 2 separate formulae in the Conditional Formatting but only condition 1 works ie C1 stays white even when "3rd Party" is in cell B1. Any help appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 conditions using conditional formatting
It can be simpler than this. The first condition below is unnecessary. The
real first condition is yellow if A1="No" and B1="3rd Party". The second condition is white if A1="No". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... this is a logic problem. here is the truth table for your problem Cell A1 No Yes No 3rd Party White Grey B1 3rd Party Yellow Grey You nee three forula in conditional formating 1) grey if A1 = Yes 2) White if A1= No and 3rd Party = No 3) Yellow is A1 = No and 3rd Party = yes "jimar" wrote: I would like a cell to change colour for 2 separate condidtions. Cell C1 is default cell colour grey. 1st condition is Cell C1 to change to white if A1 = "No". 2nd condition is C1 to change to yellow if A1 = "No" and B1 = "3rd Party". I have tried putting these in as 2 separate formulae in the Conditional Formatting but only condition 1 works ie C1 stays white even when "3rd Party" is in cell B1. Any help appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 conditions using conditional formatting
Thanks for the reply. It worked perfectly
"Jon Peltier" wrote: It can be simpler than this. The first condition below is unnecessary. The real first condition is yellow if A1="No" and B1="3rd Party". The second condition is white if A1="No". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... this is a logic problem. here is the truth table for your problem Cell A1 No Yes No 3rd Party White Grey B1 3rd Party Yellow Grey You nee three forula in conditional formating 1) grey if A1 = Yes 2) White if A1= No and 3rd Party = No 3) Yellow is A1 = No and 3rd Party = yes "jimar" wrote: I would like a cell to change colour for 2 separate condidtions. Cell C1 is default cell colour grey. 1st condition is Cell C1 to change to white if A1 = "No". 2nd condition is C1 to change to yellow if A1 = "No" and B1 = "3rd Party". I have tried putting these in as 2 separate formulae in the Conditional Formatting but only condition 1 works ie C1 stays white even when "3rd Party" is in cell B1. Any help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with 4 or more conditions | Excel Worksheet Functions | |||
Need 6 Conditions / Conditional Formatting | Excel Worksheet Functions | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting wth more than 3 conditions | Excel Worksheet Functions | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) |