Apple Pages '09 - Manual (Page 196)

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 Table button, and then click Format.
3 Click “Show rules”, and then choose an item from the “Choose a rule” pop-up menu.
The items in the top section of the menu apply tests to numeric values. Items in the
middle section are for text values. The “With dates” item is for dates.
4 To specify a specific test value, type it into the value field, to the right of the
pop-up menu.
You can also use the value in a table cell as a test value. To do so, click the small blue
circle in the value field to display the cell reference field.
Specify a cell reference by clicking in a table cell. You can also type a cell reference and
press Return.
The Between item requires that you specify two test values. The formatting is applied if
either of the numbers or any number in between them appears in the cell or cells.
196 Chapter 9 Working with Table Cells