Conditional Formatting with > 3 rules

[mbcase]

I'm trying to find a way to auto-format individual cells with different color shading when each of 6 different codes are typed in (X = green; N = grey; A = yellow; etc). I also want the code to appear as text in the cell in regular type. The conditional formatting works great with only 3 rules. But, what about 6?

Thanks in advance.

 

[dave3009]

There is an add-in called CFPlus that may help.

HTH


Dave