Microsoft Office Tutorials and References
In Depth Information
• Format Only Unique or Duplicate Values : Use this rule type to create rules that format unique or duplic-
ate 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 Conditions,” later in this chapter.
Conditional Formats That Use Graphics
This section describes the three conditional formatting options that display graphics: data bars, color scales, and
icons 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-4 shows an example of data bars. It's a list of tracks on 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.
The examples in the section are available on this topic's website. The workbook is
named data bars examples.xlsx.