Home-> Styles-> Conditional Formatting-> Icon Sets

 

Use Icon Sets

Try It: Format with Icon Sets

Select Column H.

Go to Home -> Styles.

Go to Conditional Formatting.

Select Icon Sets: Arrows (Colored)

 

What Do You See? The Icon Sets use a three, four, or five-color scale to format the data. In the example on this page, there are four Directional arrows representing the following percents:

100-75%

74-50%

49-25%
25-0%

 

What Else Do You See? The Conditional Formatting menu also lets you create a New Rule or Manage the Rules.

 

Let's investigate where Excel puts the Rules and what tools are available in the Rules Manager. Keep going...

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.3. Apply conditional formatting: Use Icon Sets