Conditional Formatting Limitations and other options?

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I want to format cells in one of 6 different ways based on the value of
another cell. Using conditional formatting and "Formula is" criteria, I
have this working for the first 3 conditions, but it appears that I cannot
any more than 3 options? Is there a workaround for this? If it matters, I'm
using Excel 2002 SP-2 on XP.

Thanks, Bryan
 
Thanks for the pointer but I don't think I can make that work. I'm looking
to change several cells based on the text value of another cell in the same
row. For example, I want to evaluate the value of ZZ1 which I know is a
text string against 6 different values. If I find a match then I want to
change the color of the font in only cells A1, B1, C1. The same logic would
apply for all subsequent rows -> check the value in col ZZ against 6
conditions and change color in col A-C to the color for the matched
condition.

A1 B1 C1 ZZ1
A2 B2 C2 ZZ2
A3 B3 C3 ZZ3

Bryan
 
Back
Top