Microsoft Office Tutorials and References
In Depth Information
FORMAT YOUR WORKSHEET
Data bars enable you to discern at a glance how large
a value in one cell is relative to the values in other
cells. A data bar is a colored bar you place in a cell.
The length of the bar represents the value of the cell
relative to other cells — the longer the bar, the higher
the value. Excel provides you with several bars from
which to choose and you can design your own.
Color scales and icon sets are similar to data bars,
except color scales use gradients of color to
represent the relative size of the cell value, and icon
sets use icons to represent the relative size of the
Data bars, color scales, and icon sets all use rules to
determine when to display what. You can use the
rules defined by Excel or you can create your own
rules. At the bottom of the data bar, color scale, or
icon set menu, click More Rules to adjust rules.
M ODIFY R ULES
1 Repeat Steps 1 to 3 listed under
l This is the selected data.
A menu appears.
Click Icon Sets.
Alternatively, you can click Data
Bars or Color Scales. Each allows
you to change the associated
A submenu appears.
Click More Rules.
l The New Formatting Rule dialog
Click here and select a rule type.
Click here and select a format
Click here and select an operator.
Type a value or click in the cell
that contains the value you want
Click here and select a type.
Note: You can choose Number,
Percent, Formula, or Percentile.