Microsoft Office Tutorials and References
In Depth Information
Using color scales
The color scale conditional formatting option varies the background color of a cell based on the cell's value, rel-
ative to other cells in the range.
A color scale example
Figure 19-6 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 3-color scale, with red (in this topic, the darkest gray) 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.
Figure 19-6: Two examples of color scale conditional formatting.
The example on the right shows the same data, but conditional formatting was applied to each region separately.
This approach facilitates comparisons within a region, and can also help identify high or low sales months.
Neither one of these approach is necessarily better. The way you set up conditional formatting depends entirely
on what you are trying to visualize.
This workbook, named color scale example.xlsx, is available at this topic's website.