Formatting PivotTable cells using icon sets


show more Formatting PivotTable cells using icon sets provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Formatting PivotTable cells using icon sets

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 indicators such as the familiar red and yellow and green stoplight images to indicate acceptable, unacceptable, and excellent results. In Excel, such a group of indicators is called an icon set. To apply an Icon Set conditional format to a PivotTable, click any cell in the PivotTable data field.

Then on the Home tab, click the Conditional Formatting buttons, point to Icon Sets, and then at the bottom click More Rules. When you do, the New Formatting Rule dialog box appears. The first thing you can do is select which cells to apply the rules to and in this case, you only want the cells in the body of the PivotTable. Not the grand total or subtotal cells. So you should select the third option, which is All cells showing "Sum of Revenue" values for "Month" and &q...

Formatting PivotTable cells using icon sets
Video duration: 2m 45s 3h 43m Intermediate

Viewers:

Formatting PivotTable cells using icon sets provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...