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