Apple Numbers '09 - Manual (Page 83)

Chapter 4 Working with Table Cells 83
To apply conditional formatting, you select one or more cells and then define one or
more rules. The rules specify which visual effects to associate with cells when they
contain the test value.
For example, you can define a rule that fills a cell with blue when it contains 0, a rule
that displays the cell’s value as boldface black if it’s greater than 0, and a rule that fills
the cell with red if its value is less than 0.
Rules applied to multiple cells trigger conditional formatting in any of the cells that
contain the test value.
To learn how to Go to
Create rules “Defining Conditional Formatting Rules” on
page 83
Remove all conditional formatting from cells,
change rules, find cells that use the same
conditional formatting, copy/paste conditional
formatting between tables “Changing and Managing Your Conditional
Formatting” on page 85
Defining Conditional Formatting Rules
A conditional formatting rule is used to detect when cells contain a test value, which
can be either a specific value that you supply or a value that matches a value currently
in a specific table cell. The rule specifies the formatting to apply to the cells when they
contain the test value.
To define rules:
1 Select one or more cells.
2 Click Inspector in the toolbar, click the Cells inspector button, and then click “Show rules.”
You can also choose Format > Show Conditional Format Rules.
3 Choose an option from the “Choose a rule” pop-up menu.
The options in the top section of the menu apply tests to numeric values. Options in
the middle section are for text values. The “With dates” option is for dates.