Hi all,
I understand the concept of conditional formatting in spreadsheets in
XL 2003 just fine.

Can the same functionality be extened to XL Charts? I am thinking it
has to be a VBA solution, which is not a problem. I just wanted a
sanity or insanity check before doing it all with VBA.

Looking for evaluating values and formatting differently and finding
test strings and formatting them in same color. Best example there is
Coke vs. Pepsi.

Coke should always be Red and Pepsi should always be Blue no matter
where they show up in something like a Share of Market Chart.

Coke is highest share overall and therefore the first colorindex(x)
but Pepsi, as I recall, has the highest share, or at least used to, in
Fountain sales and should always show up as Blue(other colorindex).

I know how to do this with Table-based programming lookup table but
was wondering if it was already built in.

Thank you,

Brian Reilly, PowerPoint MVP