Microsoft Office Tutorials and References
In Depth Information
Highlighting Trends and Variations in Data
Based on the results of those tests, Excel applies special formatting (typically colors and
borders) to each cell that satisfies a particular condition. You can combine multiple rules in
the same selection, highlighting values in the top 20 percent in bold green text on a light
green background, with values in the bottom 20 percent displayed in bold red italics on a
light red background, as shown in Figure 13-18.
Figure 13-18 The bold italic values here use dark red on a light red background, while bold
values are highlighted in green. These two rules make it easier to spot high and low values.
You can apply color scales to an entire range using a gradient of two or three colors—mov-
ing from red to yellow to green as the values in the selection go from low to high. You can
also add small data bars to a range to visually depict the values in each cell, as shown here.