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
particular cell, select the cell, click Inspector in the toolbar, click the Table button, click
“Show rules” in the Format pane, and then click “Select All with this Format.” Cells with
matching rules are selected in the table.
To remove all conditional formatting associated with cells in a table, select the cells, click
“Show rules” in the Format pane of the Table inspector, and then click Clear All Rules.
To apply the same conditional formatting rules to cells in different tables, select a
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
in the Conditional Format window.
To change a rule, redefine its pop-up menu options, test values, or formatting.
Here are some techniques for working with test values that are specified as
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.