Pivot Chart Conditional Formatting

[ashfire]

hi,

I have a pivot chart that covers the status (red, amber, green) of various
locations, each of these locations is covered by a manager. Each manager only
wishes to know how many Red, Amber, Greens he has at any given time. Their
manager wishes to see all this info in one go.

So i have set up a pivot chart that does this, but i have to manually change
the color from the default purple. Is there a way conditionally format the
sum of total status, so that the red column is coloured red etc etc.

thanks