Microsoft Office Tutorials and References
In Depth Information
Applying Conditional Formatting
Using Data Bars, Color Scales,
and Icon Sets
These graphical, interactive tools are found in
the Conditional Formatting button’s menu. Your
three options, Data Bars, Color Scales, and Icon
Sets, allow you to select a range of cells and then
choose how they’ll be graphically quantified. As
shown in Figure 5-39, if a Gradient Fill Data Bar
is applied to the Salary column, the lowest salary
($6,000) gets a really short gradient bar, and the
highest salary, $60,000, gets a long gradient bar.
It essentially turns the selected column into a
horizontal bar graph. The Color Scales and Icon
Sets create a similar effect, applying colors and
shapes (arrows, dots, flags, and so on) to indicate
values within the selected cells.
To apply the effects—not just preview them as I
suggested by having you mouse over them to
see how they look applied to your data—simply
click on one of the icons in the Data Bars, Color
Scales, or Icon Sets palettes. If you edit your
data, the effects change to reflect that, so that
an increase, for example, in the $6,000 salary
would result in a longer gradient bar.
If you ever want to get rid of the bars,
scales, or icons, simply select the range
and use the Clear Rules command from
the Conditional Formatting button’s
menu. You can choose to clear the rules
from the selected cells or the entire
Figure 5-39
Mouse over the various Data Bars, Color Scales,
and Icon Sets options, and see them applied
to your selected data.
Search JabSto ::

Custom Search