User Guide

Fill color well: Click it to select a cell ll color.
As you click, the Sample box displays the eect of your selections. When you’re
satised with the eect, click Done.
6 To add another rule, click the Add button (+) and repeat steps 3 through 5.
If more than one rule is dened for a cell, and the cell’s value satises the conditions of
multiple rules:
The text color applied is the color associated with the topmost rule with a text color Â
specied.
The font style applied is the font style associated with the topmost rule that has a Â
font style specied.
The ll color applied is the ll color associated with the topmost rule that has a ll Â
color specied.
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 nd all the cells in a table that have the same conditional formatting rules as m
a 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 dierent tables, select m
a cell whose rules you want to reuse, choose Edit > Copy, select one or more cells
in a dierent 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.
82 Chapter 4 Working with Table Cells