Using Conditional Formatting

Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.

To remove conditional formatting rules:

  1. Select the cells that have conditional formatting.
  2. In the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
  3. Select Clear Rules.
  4. A menu will appear. You can choose to clear rules from the Selected Cells, Entire Sheet, This Table, or This PivotTable. In this example, we'll clear rules from the entire sheet.
    Clearing RulesClearing Rules

You can edit or delete individual rules by clicking the Conditional Formatting command and selecting Manage Rules. This is especially useful if you have applied multiple rules to the cells.