Add Conditional Formatting

You can use conditional formatting to add visual enhancements on reports.

For example, you can specify automatic highlighting of cells that meet certain criteria, data bars, color scales, or icon sets.

To add conditional formatting, complete the following steps:

  1. Click the Home tab.
  2. In the Styles group, click Conditional Formatting.