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