Beginning Pivot Tables in Excel 2007

CHAPTER 10Enhancing Pivot TableFormatting

Pivot tables are excellent tools for summarizing and presenting data, but sometimes the amount of data they contain is overwhelming. To ensure that the key information is delivered, you can use special formatting features to highlight the most important numbers or to replace the numbers altogether.

In this chapter, you'll use conditional formatting to color cells in a pivot table, and you'll add data bars to illustrate the amounts. You'll also add icons, such as red, yellow, and green traffic lights to indicate progress or decline or to indicate good or poor results. With conditional formatting, you'll color only the values that fall within a specific date range or those that are above or below a certain ...