Microsoft Office Tutorials and References
In Depth Information
Conditional Formatting
Chapter 10
Making Your Worksheet Look Good
7.
Repeat Steps 2 through 6 to apply any
additional conditions.
Color Scales: Designed to visually help you
understand your data, color scales compare a
range of cells by using two colors
representing higher or lower values or three colors
representing higher, middle, or lower values. The
color scale bars come in eight color themes,
including red, yellow, and green. You can also
create your own scheme by choosing More
Rules under the Color Scales options.
Clear Conditional Formatting
To clear conditional formats, go to the Home
tab and choose Styles>Conditional
Formatting>Clear Rules>Clear Rules from
Selected Cells.
Icon Sets: Icon sets help you classify data
into three, four, or five categories with each
icon representing a range of values such as
higher, middle, and lower. As shown in
Figure 10-33, icon sets include arrows,
traffic lights, clocks, and even flags.
Another form of conditional formatting is the Data
Visualization. With Data Visualizations, you see
your data conditions even better in the form of
gradient colors, data bars, and icon sets.
Select the cells to which you want to apply
formatting and choose Home>Styles>Conditional
Formatting. Select from the following options.
(Figure 10-32 shows an example of all three data
visualizations.)
Figure 10-33
Select the icon symbol you want to use to
represent your data.
Figure 10-32
Using data visualizations.
Data Bars: A gradient-style bar helps you
see the value of a cell relative to other cells.
The length of the data bar represents the
value in the cell, so a longer bar represents
a higher value and a shorter bar represents
a lower value. The data bars have six color
options designed to match Excel themes.
Icon Size
The icon size you see depends on the cell
font size. You may need to adjust the column
width to accommodate the icon.
Search JabSto ::




Custom Search