Excel 2013
Conditional Formatting
Challenge!
- Open an existing Excel workbook. If you want, you can use the Lesson 26 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 over $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.