Apple Pages User's Guide download pdf (Page 196)

Dening Conditional Formatting Rules

A conditional formatting rule is used to detect when cells contain a test value, which

can be either a specic value that you supply or a value that matches a value currently

in a specic table cell. The rule species the formatting to apply to the cells when they

contain the test value.

To dene 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 specic test value, type it into the value eld, 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 eld to display the cell reference eld.

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.

19 6 Chapter 9 Working with Table Cells

1 ... 195 196 197 ... 279

No comments

Apple Pages User's Guide Page 196