Excel 2013

Challenge!

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