| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
More than 3 Conditional Formatting Conditions
I'm aware that excel 2000 limits conditional formatting to 3 conditions. I
would like to use 8. I have a column with data validation applied in which the user can only select and enter 1 of 8 values. If they enter "DW", then fill color = blue; if "O" then fill color = purple; if "AB", then fill color = orange; if "ZY" then fill color = gray.... etc. How can I get around the limit of 3 conditional formatting conditions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
| Extend conditional formatting to more than 3 conditions | Excel Worksheet Functions | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
Threaded Mode
