Course summary: Take conditional formatting to the next level

Edit conditional formatting rule precedence

  1. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules.

    The list of conditional formatting rules are displayed for the current selection including the rule type, the format, the range of cells the rule applies to, and the Stop If True setting.

    If you don't see the rule that you want, in the Show formatting rules for list box, make sure that the right range of cells, worksheet, table, or PivotTable report is selected.

  2. Select a rule. Only one rule can be selected at a time.

  3. To move the selected rule up in precedence, click Move Up. To move the selected rule down in precedence, click Move Down.

  4. Optionally, to stop rule evaluation at a specific rule, select the Stop If True check box.

Format all cells by using a three-color scale

  1. Select one or more cells in a range, table, or PivotTable report.

  2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Color Scales.

  3. Select a three-color scale. The top color represents higher values, the center color represents middle values, and the bottom color represents lower values.

See also

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×