Microsoft Office Tutorials and References
In Depth Information
Applying Conditional Formatting
Once it’s open, follow these steps:
3. When you like the Preview colors (which
varies, depending on your choice under
Format Style), click OK. The formatting is
applied, per the rules you created in the Edit
the Rule Description section of the dialog
box. Figure 5-38 shows the result, where the
lowest to highest values were shaded from
dark orange to light orange (lowest values
having a darker cell fill color).
1. Select a Rule Type, choosing from the six
2. Edit the rule. You can set the following
Format Style. Choose 2-Color Scale,
3-Color Scale, Data Bar, or Icon Sets.
You’ll learn more about these in the
subsequent section of this chapter.
Value Type Minimum and Maximum.
Choose what kind of value Excel
should look for—numbers, percents,
formulas, or set a Lowest and Highest
Value. You choose Number here so you
can set a range in the next field, to
highlight everyone whose salary is
between 50,000 and 100,000.
Value. Here’s where you enter the
values that Excel should seek—you’ll
enter 50,000 on the Minimum side,
and 100,000 on the Maximum side.
Colors were applied to the cells meeting
Color. Choose from Themes colors,
Standard Colors, or click More Colors
to choose from any of millions of
possible shades. You can apply different
colors for the low and high values.
Want to get rid of the conditional
formatting, however it was applied? Click
the Clear Rules command, found in the
Conditional Formatting button’s menu.
The resulting submenu lets you choose
which rules to clear—from the selected
cells, or the entire worksheet. If you
made a selection before issuing this
command, simply choose the Clear Rules
From Selected Cells command, and all
formatting applied by your conditional
formatting rules is removed.