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.

Conditional formatting based on category
 

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.