I have conditional formats on cells so that a color is generated based on
what number is in the cell. When I make a simple bar graph, the data series
is all one color. Without having to change each bar individually is there a
quicker way of doing this?