Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.
- Open an existing Excel workbook. If you want, you can use our practice workbook.
- Apply conditional formatting to a range of cells with numerical values. If you are using the example, apply a rule for the sales data (cells B3:G23) that will fill cells with green if their values are more than $9000.
- Apply a second conditional formatting rule to the same set of cells. If you are using the example, apply a preset conditional formatting rule.
- Clear all conditional formatting rules from the worksheet.