
Chapter 4 Working with Table Cells 85
As you click, the Sample box displays the eect of your selections. When you’re
satised with the eect, click Done.
6 To add another rule, click the Add button (+) and repeat steps 3 through 5.
If more than one rule is dened for a cell, and the cell’s value satises the conditions of
multiple rules:
The text color applied is the color associated with the topmost rule with a text Â
color specied.
The font style applied is the font style associated with the topmost rule that has a Â
font style specied.
The ll color applied is the ll color associated with the topmost rule that has a ll Â
color specied.
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 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 dierent tables, select a m
cell whose rules you want to reuse, choose Edit > Copy, select one or more cells in a
dierent 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, redene its pop-up menu options, test values, or formatting. Here are m
some techniques for working with test values that are specied as cell references:
Comentarios a estos manuales