Conditional Formatting for more than 3 conditions

N

Neon520

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Conditional Formatting from a group 6
Conditional Formatting 4th Condition 3
Conditional Formatting within a Time Sheet 0
Possible Conditional Formatting 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional Formatting with VBA 4
Conditional Formatting for a dashboard with a drop down menu 0

Top