Applying a conditional formatting specification

When you open the conditional formatting pane, a number of default conditional formatting specifications are available. You can apply these specifications directly to the items on your chart.

Procedure

To apply a conditional formatting specification:
  1. To open the Conditional Formatting pane, click the Style tab, and then click Conditional Formatting > Conditional Formatting Pane.
  2. In the Conditional Formatting pane, from the commands in the Actions panel at the bottom of the pane, select:
    OptionDescription
    Format with Selected Specification Use the specification that is selected in the upper part of the Conditional Formatting pane to format all items on the current chart.
    Format Selected Items with Selected Specifications Use the specification that is selected in the upper part of the Conditional Formatting pane to format items that are selected on the chart.
    Undo Formatting Remove the last conditional formatting specification that was applied.
    Any items on your chart that meet the criteria will be modified, a Formatting progress status window will notify you of the changes that are made.
  3. Click Close to return to your chart.