Conditional formatting based on category

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top