From the course: Excel: PivotTables in Depth

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Format cells using icon sets

Format cells using icon sets

From the course: Excel: PivotTables in Depth

Start my 1-month free trial Buy for my team

Format cells using icon sets

“

- [Instructor] One of the most popular trends in corporate management is to use icons to indicate how a company's performance compares to its goals. If you set up your workbook as a dashboard that summarizes performance, you can use indicators such as the familiar red, yellow, and green stoplight images to indicate unacceptable, acceptable, and excellent results. In Excel, this group of indicators is called an icon set. I'll show you how to apply them as a conditional format. My sample file is 05_05_IconSets, and you can find it in the chapter 5 folder of the Exercise Files collection. On Sheet1, I have a PivotTable that summarizes the quantity of units sold for each of my categories. And also, I will assume that I want to apply the same conditional formatting rule to each of the categories. I'll start by clicking any value cell, and then on the Home tab of the ribbon, click Conditional Formatting, and then point to Icon Sets. And here, I have a list of shapes that I can use, and…

Contents