Conditional Formatting

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

Conditional formatting presets

Excel has several predefined styles—or presets—you can use to quickly apply conditional formatting to your data. They are grouped into three categories:

To use preset conditional formatting:

  1. Select the desired cells for the conditional formatting rule.
    Select cells
  2. Click the Conditional Formatting command. A drop-down menu will appear.
  3. Hover the mouse over the desired preset, then choose a preset style from the menu that appears.
    The presets on the Conditional Formatting menu
  4. The conditional formatting will be applied to the selected cells.
    The preset has been applied to the worksheet

Removing conditional formatting

To remove conditional formatting:

  1. Click the Conditional Formatting command. A drop-down menu will appear.
  2. Hover the mouse over Clear Rules, and choose which rules you want to clear. In our example, we'll select Clear Rules from Entire Sheet to remove all conditional formatting from the worksheet.
    Clear Rules on the Conditional Formatting menu
  3. The conditional formatting will be removed.
    The conditional formatting has been removed

Click Manage Rules to edit or delete individual rules. This is especially useful if you've applied multiple rules to a worksheet.

The Conditional Formatting Rules Manager