Quickly Apply a Formatting Rule
This procedure summarizes the process of adding a global formatting rule to a table.
1. Right-click on the table column heading, then select Edit Global Conditional Formatting. The Conditional Formatting dialog box is displayed.
2. Click Add. The Edit Rule dialog box is displayed.
3. Add the condition(s) to be met for the formatting rule to be applied.
a. Select the Column, Operator, and Value(s), then click Add to List.
b. Repeat this step if the formatting rule requires more than one condition to be met.
4. Click the Formatting tab.
6. Click OK. The dialog box closes and the rule is added to the List of Rules.
7. Click OK to close the Conditional Formatting dialog box.