Microsoft Office Tutorials and References
In Depth Information
selected when you double-click it) to restore the button to its unselected
state and return the mouse pointer to its normal thick, white cross shape.
You can use the Format Painter to restore a cell range that you gussied all up
back to its boring default (General) cell format. To do this, click an empty,
previously unformatted cell in the worksheet before you click the Format Painter
button and then use the Format Painter pointer to drag through the cells you
want returned to the default General format.
Before leaving behind the scintillating subject of cell formatting, there’s one
more formatting button in the Styles group of the Home tab of which you
need to be aware. The Conditional Formatting button enables you to apply
provisional formatting to a cell range based solely on the categories into
which its current values fall. The cool thing about this kind of conditional
formatting is that should you edit the numbers in the cell range so that their
values fall into other categories, the program automatically changes their cell
formatting to suit.
When you click the Conditional Formatting button in the Styles group of the
Home tab, a drop-down menu appears with the following options:
✓ Highlight Cells Rules opens a continuation menu with various options
for defining formatting rules that highlight the cells in the cell selection
that contain certain values, text, or dates; that have values greater or
less than a particular value; or that fall within a certain ranges of values.
✓ Top/Bottom Rules opens a continuation menu with various options for
defining formatting rules that highlight the top and bottom values,
percentages, and above and below average values in the cell selection.
✓ Data Bars opens a palette with different color data bars that you can
apply to the cell selection to indicate their values relative to each other
by clicking the data bar thumbnail.
✓ Color Scales opens a palette with different two- and three-colored scales
that you can apply to the cell selection to indicate their values relative
to each other by clicking the color scale thumbnail.
✓ Icon Sets opens a palette with different sets of icons that you can apply
to the cell selection to indicate their values relative to each other by
clicking the icon set.
✓ New Rule opens the New Formatting Rule dialog box where you define a
custom conditional formatting rule to apply to the cell selection.