Excel tips & how-to, page 24

Conditional formatting in Excel Pivot Tables

With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading