Microsoft Office Tutorials and References
In Depth Information
Conditional Formats That Use Graphics
Use the New Formatting Rule dialog box to adjust any of the conditional format rules
available via the Ribbon, as well as creating unique new rules. First, select a general rule
type from the list at the top of the dialog box. The bottom part of the dialog box varies,
depending on your selection at the top. After you specify the rule, click the Format button
to specify the type of formatting to apply if the condition is met. An exception is the fi rst
rule type (Format All Cells Based on Their Values), which doesn’t have a Format button (it
uses graphics rather than cell formatting).
Here is a summary of the rule types:
Format all cells based on their values: Use this rule type to create rules that
display data bars, color scales, or icon sets.
Format only cells that contain: Use this rule type to create rules that format cells
based on mathematical comparisons (greater than, less than, greater than or equal
to, less than or equal to, equal to, not equal to, between, not between). You can
also create rules based on text, dates, blanks, nonblanks, and errors.
Format only top- or bottom-ranked values: Use this rule type to create rules that
involve identifying cells in the top n, top n%, bottom n, and bottom n%.
Format only values that are above or below average: Use this rule type to create
rules that identify cells that are above average, below average, or within a specifi ed
standard deviation from the average.
Format only unique or duplicate values: Use this rule type to create rules that
format unique or duplicate values in a range.
Use a formula to determine which cells to format: Use this rule type to create
rules based on a logical formula (see “Creating Formula-Based Rules,” later in this
Conditional Formats That Use Graphics
This section describes the three conditional formatting options that display graphics: data
bars, color scales, and icon sets. These types of conditional formatting can be useful for
visualizing the values in a range.
Using data bars
The data bars conditional format displays horizontal bars directly in the cell. The length of
the bar is based on the value of the cell, relative to the other values in the range.
A simple data bar
Figure 19.14 shows an example of data bars. It’s a list of tracks on 37 Bob Dylan albums,
with the length of each track in column D. I applied data bar conditional formatting to the
values in column D. You can tell at a glance which tracks are longer.
Search JabSto ::

Custom Search