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

One possible way

http://www.mcgimpsey.com/excel/conditional6.html

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Bryan" <(E-Mail Removed)> wrote in message
news:j140d.17707$aW5.17453@fed1read07...
>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

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> One possible way
>
> http://www.mcgimpsey.com/excel/conditional6.html
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please, for everyone's
> benefit keep the discussion in the newsgroup/forum)
>
>
>
> "Bryan" <(E-Mail Removed)> wrote in message
> news:j140d.17707$aW5.17453@fed1read07...
> >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
> >
> >
>
>