Conditional Formatting

You are here:
Estimated reading time: < 1 min

Conditional formatting quickly highlights important information in a chart.

From the Format > Chart menu, select Conditional formattingClick ADD A RULE

Select a rule from a menu, enter the value and choose the formatting style. Click APPLY.

NOTE: conditional formatting enables you to create a rule for number-type values only.

You can use more than one rule for each chart. To set the order, drag and drop the rule in the list. Note that the last rule in the list has a higher priority than the first one.

Click the rule to edit it. 

Was this article helpful?
Dislike 0
Views: 226