Importing a conditional formatting rule

You can copy rules from a conditional formatting specification into the specification you are currently defining. All specifications in your Local and Workgroup folders are listed in the top half of the Conditional Formatting pane.

Procedure

To import a rule:
  1. To open the Conditional Formatting Specifications window, click the Style tab, and then click Conditional Formatting > Saved Specifications.
  2. Click Format with new specification, or select an existing specification and click Edit to show the Edit Conditional Formatting Specification window.
  3. Click Import.
  4. Locate and select the specification that you want to import from.

    All rules in a selected specification are listed in the bottom half of the window.

  5. Select the rules that you want to import by selecting the relevant check boxes.
  6. Click Import.

    The selected rules are copied to the Edit Conditional Formatting Specification window.