Formatting Rules

Formatting rules are used to visually differentiate between different sets of information.

To use formatting rules, follow the steps below.

  1. In the View tab, click Edit Formats.
  2. To add a rule, click New Rule.... Or, click Edit Rule... to update an existing one.
  3. Select one of the below rule types and fill in the fields provided:
    • Format all cells based on their values
    • Format only cells that contain
    • Format only top or bottom ranked values
    • Format only values that are above or below average
    • Format only unique or duplicate values
    • Use a formula to determine which cells to format
  4. Click OK, Apply, then OK.