Style and Conditional Formatting dialog: Conditional Formatting tab

Use this tab of the "Style and Conditional Formatting dialog" to format a graph based on conditions applied to columns.

For more information, see:

"Formatting the Visual Appearance of Graphs"

Components

Column tabs

Displays tabs for each column to which you can add conditions. Click a column tab to display the conditions that are currently defined for the column. You can modify a condition using its Condition toolbar.

Add Condition Format

Use this button to add a condition. This button first displays a list of the columns to which you can apply conditional formatting and then, when you select a column, the "New Condition dialog," where you define the condition to add.

Clear All

Use this button to delete all conditions on the current column tab.

Condition Toolbar

The condition toolbar is the collection of components that displays to the right of a condition. It includes the following components:

Edit— Use this button to display the New Condition dialog, where you edit the condition.
Color — Use this box to display the Color Selector dialog, where you select the color to be applied to the column values that meet the condition.
Delete— Use this button to delete the condition.