Home -> Styles->Conditional Formatting  -> Manage Rules

 

The Rules Manager

Before You Begin: In this example, Column H is the Amount, sorted Descending. Column H has the Icon Set Conditional Formatting,

 

1. Try It: Use the Rules Manager

Go to Home -> Styles.

Go to Conditional Formatting.

Click on Manage Rules.

 

 

What Do You See? The Rules Manager should display a list of the Conditional Formatting. You can add, delete, and edit the Rules here.

 

2. Try This, Too: Edit the Rule

Click on Edit Rule...

 

Keep going, pleeeeeease...

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.3. Apply conditional formatting: Manage the Rules