Modifying Conditional Formats

Conditional Formatting Rules can be edited, deleted or reordered at any time.

Editing Conditional Formats

You may need to modify the criteria for a condition or the format that is applied to boxes that meet a condition.

To edit a conditional format:

1        Click the Format tab and select Conditional Formatting to display the Conditional Formatting dialog box listing all the defined Conditional Formatting Rules.

2        Select a condition and click Edit to modify the condition’s criteria.

3        Click the Format Box, Format Fields or Format Connector buttons to modify the format. Click Clear Format to reset the formatting.

4        Click OK to close the Conditional Formatting dialog box. 0

Deleting Conditional Formats

You can remove a conditional format at any time.

To delete a conditional format:

1        Click the Format tab and select Conditional Formatting to display  the Conditional Formatting dialog box.

2        Select a condition.

3        Click Delete. A confirmation dialog box is displayed.

4        Click Yes to delete the condition.

5        Click OK to close the Conditional Formatting dialog box. 0

Reordering Conditional Formats

Each condition is applied to the chart starting with the first condition and ending with last condition. Any box in your chart may satisfy two or more conditions. In this case you may need to reorder conditions to achieve the desired formatting.

To reorder a conditional format:

1        Click the Format tab and select Conditional Formatting to display the Conditional Formatting dialog box.

2        Select a condition.

3        Click the up arrow  to move the condition up.

4        Click the down arrow  to move the condition down.

5        Click OK to close the Conditional Formatting dialog box. 0