Microsoft Office Tutorials and References
In Depth Information
Specifying Conditional Formatting
Color scale: The background color varies, depending on the value of the cells. You
can choose from several different color scales or create your own.
Icon set: One of several icon sets. It displays a small graphic in the cell. The
graphic varies, depending on the cell value.
Icon set: Another icon set, with all but one icon in the set hidden
Custom rule: The rule for this checkerboard pattern is based on a formula:
=MOD(ROW(),2)=MOD(COLUMN(),2)
Specifying Conditional Formatting
To apply a conditional formatting rule to a cell or range, select the cells and then use one of
the commands from the Home Styles Conditional Formatting drop-down list to specify a
rule. The choices are:
Highlight Cell Rules: Examples include highlighting cells that are greater than a
particular value, between two values, contain specifi c text string, contain a date,
or are duplicated.
Top Bottom Rules: Examples include highlighting the top ten items, the items in
the bottom 20%, and items that are above average.
Data Bars: Applies graphic bars directly in the cells, proportional to the cell’s value
Color Scales: Applies background color, proportional to the cell’s value
Icon Sets: Displays icons directly in the cells. The icons depend on the cell’s value.
New Rule: Enables you to specify other conditional formatting rules, including
rules based on a logical formula
Clear Rules: Deletes all the conditional formatting rules from the selected cells
Manage Rules: Displays the Conditional Formatting Rules Manager dialog box, in
which you create new conditional formatting rules, edit rules, or delete rules
Formatting types you can apply
When you select a conditional formatting rule, Excel displays a dialog box specifi c to
that rule. These dialog boxes have one thing in a common: a drop-down list with common
formatting suggestions.
Figure 19.12 shows the dialog box that appears when you choose
Home Styles Conditional Formatting Highlight Cells Rules Between. This particular
rule applies the formatting if the value in the cell falls between two specifi ed values. In
this case, you enter the two values (or specify cell references), and then use choices from
the drop-down list to set the type of formatting to display if the condition is met.
Search JabSto ::




Custom Search