Thread: Conditional formatting based on category

I am making a series of bar charts that use the same categories (i.e. school
name). The bar for each school needs to have a unique color, which will
remain the same in each chart. Also, the order in which the schools are
listed may vary from chart to chart. I assume a macro could be constructed
to perform this type of conditional formating? Any assistance would be
appreciated. Thanks.

This site helped me...
http://peltiertech.com/Excel/Charts/...nalChart1.html

"Scott Bucher" wrote:

> I am making a series of bar charts that use the same categories (i.e. school
> name). The bar for each school needs to have a unique color, which will
> remain the same in each chart. Also, the order in which the schools are
> listed may vary from chart to chart. I assume a macro could be constructed
> to perform this type of conditional formating? Any assistance would be
> appreciated. Thanks.
>
>