Excel 2007


Using Conditional Formatting
Challenge!
Use the Company Sales workbook to complete this challenge.
- Apply conditional formatting to a range of cells with numerical values.
- Apply a second conditional formatting rule to the same set of cells.
- Apply a conditional formatting rule to a range of cells with text.
- Explore the Conditional Formatting Rules Manager dialog box.
- Clear all conditional formatting rules from the worksheet.