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:
To delete a test value that’s a cell reference, click in the test value field and press Delete.
To replace a cell reference with a different one, click in the test value field and click a
different cell in the same table or a different table.
To replace a textual test value with a cell reference, click in the test value field, click the
small blue circle, and then click a table cell.