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.

Conditional formatting presets

Excel has several presets you can use to quickly apply conditional formatting to your cells. They are grouped into three categories:

To use preset conditional formatting:

  1. Select the cells you want to add formatting to.
  2. In the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
  3. Select Data Bars, Color Scales, or Icon Sets. Then select the desired preset.
    Selecting a formatting presetSelecting a formatting preset
  4. The conditional formatting will be applied to the selected cells.
    The finished Data BarsThe finished Data Bars