Home -> Conditional Formatting  -> Manage Rules

 

Bend the Rules

3. What Do You See? The Rule Type is a list of options. You can use a Rule to identify a cell by the values. The values can be based on the average or the rank. You can also use a formula in a rule.

 

The Rule Description is a tool for defining the values. You can select the formatting Style and type in your own Value if you wish.

 

You can edit each part of the Rule Description including the Icons, the values and the colors if you wish.

 

It's kind of fun. Click OK to return to the Rules Manager, and OK, again, to close the Rules Manager.

 

Very Good!

 

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.3. Apply conditional formatting: Manage the Rules