Conditional Formatting

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

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. 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.
  3. Apply a second conditional formatting rule to the same set of cells. If you are using the example, apply a preset conditional formatting rule.
  4. Clear all conditional formatting rules from the worksheet.