| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for more than 3 conditions
Hi everyone,
I have 6 categories of items, and I want to conditionally format the 7th column to show six different color according to which one of the six categories has been selected. (note: the 7th column is a drop-down list, which consist of the 6 different categories) The Conditional Formatting in Excel only allow ONLY 3 different conditional formatting, and I need 6, what can I do? Thank you, GU |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting for more than 3 conditions
This question resurfaces every once in a while:
http://www.microsoft.com/office/comm...=en-us&m=1&p=1 Regards, Ryan-- -- RyGuy "Neon520" wrote: Hi everyone, I have 6 categories of items, and I want to conditionally format the 7th column to show six different color according to which one of the six categories has been selected. (note: the 7th column is a drop-down list, which consist of the 6 different categories) The Conditional Formatting in Excel only allow ONLY 3 different conditional formatting, and I need 6, what can I do? Thank you, GU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting--Need 4 conditions | Excel Discussion (Misc queries) | |||
| Need 6 Conditions / Conditional Formatting | Excel Worksheet Functions | |||
| Need more than 2 conditions in Conditional Formatting | Excel Worksheet Functions | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| Conditional formatting wth more than 3 conditions | Excel Worksheet Functions | |||
Linear Mode
