Apple Numbers '09 Manual do Utilizador descarregar pdf (Página 83)

Chapter 4 Working with Table Cells 83

To apply conditional formatting, you select one or more cells and then dene one or

more rules. The rules specify which visual eects to associate with cells when they

contain the test value.

For example, you can dene a rule that lls 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 lls

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 “Dening Conditional Formatting Rules” on

page 83

Remove all conditional formatting from cells,

change rules, nd cells that use the same

conditional formatting, copy/paste conditional

formatting between tables

“Changing and Managing Your Conditional

Formatting” on page 85

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 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.

1 2 ... 78 79 80 81 82 83 84 85 86 87 88 ... 92 93

Sem comentários

Apple Numbers '09 Manual do Utilizador Página 83