Microsoft ® Office 2007 Business Intelligence

2.8. Conditional Formatting Inside a PivotTable

Excel 2007 takes the concept of conditional formatting to a new level. It's easy to apply color or icon schemes to selected cells of data (row or column) and produce a stunning visualization of the range of numeric values across the cells. We'll show some fast default ways to apply these color visuals—but we won't go into the sophistication of arithmetic rules that can be used to minutely control the conditional formatting. Suffice it to say that it's possible to take Excel conditional formatting to a level of statistical analysis if you explore these tools further!

2.8.1. Conditional Formatting Data Bars

Figure 2-45 shows the surprising result of adding data bars to a column of data. Longer data ...