Microsoft Office Tutorials and References
In Depth Information
Using color scales
conditional formatting in column D (column D contains references to the values in column C).
The conditional formatting in column D uses the Show Bars Only option, so the values are not
displayed.
FIGURE 19.15
Comparing data bars conditional formatting (top) with a bar chart.
Figure 19.15 also shows an actual bar chart created from the same data. The bar chart takes
about the same amount of time to create and is a lot more fl exible. But for a quick-and-dirty
chart, data bars may be a good option — especially when you need to create several such charts.
Using color scales
The color scale conditional formatting option varies the background color of a cell based on
the cell’s value, relative to other cells in the range.
A color scale example
Figure 19.16 shows examples of color scale conditional formatting. The example on the left
depicts monthly sales for three regions. Conditional formatting was applied to the range
B4:D15. The conditional formatting uses a three-color scale, with red for the lowest value,
yellow for the midpoint, and green for the highest value. Values in between are displayed
using a color within the gradient. It’s clear that the Central region consistently has lower
sales volumes, but the conditional formatting doesn’t help identify monthly difference for a
particular region.
Search JabSto ::




Custom Search