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.
    Screenshot of Excel 2013Selecting the desired 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.
    Screenshot of Excel 2013Applying a preset conditional formatting rule
  4. The conditional formatting will be applied to the selected cells.


    Screenshot of Excel 2013The applied conditional formatting preset