Microsoft Office Tutorials and References
In Depth Information
Applying Conditional Formatting
4. Enter a value in the field on the left side of
the dialog box, and then choose the type
of highlighting to apply from the drop-down
menu on the right.
The Top/Bottom Rules command works
just like the Highlight Cells Rules
command, except that you’re choosing from
six rules for top and bottom values. The
top 10, the bottom 10, the cells
containing above or below average values—these
can all be identified and formatted per
your instructions in the resulting Rules
5. Click OK, and view your worksheet to see
which cells were found to meet the
conditions, and see that the selected formatting
has been applied to them, as shown in
Creating a New Rule
If you’d rather take a more methodical approach,
with more ways to customize the conditions and
the resulting formatting, you can use the New
Formatting Rule dialog box, shown in Figure 5-37.
This dialog box is opened by selecting a portion
of your worksheet (where the conditions are to
be found) and choosing New Rule from the
Conditional Formatting button’s menu.
Two employees’ salaries meet the conditions, and are
formatted to stand out among the rest of the list.
Providing Formatting Conditions
Each of the commands in the Highlight Cells
Rules submenu presents a similar dialog
box, and all you have to do is provide the
conditions and tell Excel what sort of
formatting to apply, using the list of preset
Work with various rule presets and create
your own custom formatting for those cells
that meet your conditions.