| 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. |
| 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) | |||
Threaded Mode
