Apple Numbers '09 - Manual (Page 85)

Chapter 4 Working with Table Cells 85
As you click, the Sample box displays the effect of your selections. When you’re
satisfied with the effect, click Done.
6 To add another rule, click the Add button (+) and repeat steps 3 through 5.
If more than one rule is defined for a cell, and the cell’s value satisfies the conditions of
multiple rules:
The text color applied is the color associated with the topmost rule with a text Â
color specified.
The font style applied is the font style associated with the topmost rule that has a
Â
font style specified.
The fill color applied is the fill color associated with the topmost rule that has a fill
Â
color specified.
After the text color you specify has been applied to a cell value, if you type new text
into the cell after placing an insertion point and changing the text color in the format
bar or the Text inspector, the new text appears in the new text color, but the existing
text retains the color you set in the rule.
Changing and Managing Your Conditional Formatting
Here are techniques you can use:
To find all the cells in a table that have the same conditional formatting rules as a
m
particular cell, select the cell, click “Show rules” in the Cells inspector, and then click
“Select All.” Cells with matching rules are selected in the table.
To remove all conditional formatting associated with cells in a table, select the cells, m
click “Show rules” in the Cells inspector, and then click Clear All Rules.
To apply the same conditional formatting rules to cells in different tables, select a
m
cell whose rules you want to reuse, choose Edit > Copy, select one or more cells in a
different table, and then choose Edit > Paste.
To add or remove a conditional formatting rule, click the Add (+) or Delete (–) button
m
in the Conditional Format window.
To change a rule, redefine its pop-up menu options, test values, or formatting. Here are
m
some techniques for working with test values that are specified as cell references: