Database Reference
In-Depth Information
FI g u R e 15 -27
Conditional formatting rules window
Repeat this process at the country level, using yellow and red (you could choose
any color you want, as long as it doesn't overlap with the existing color sets).
The result is a table looking similar to the one shown in Figure 15-28.
FI g u R e 15 -28
Multiple conditional formatting rules applied to a pivot table
It is important to note that the conditional formatting is relative to the data
currently visible: drilling down on Europe. (Take note of the change in the
coloring for South Africa, as seen in Figure 15-29.)
