The key to Conditional Formatting Pivot Tables in 2007, is in the way you
select the range.
In a PT you cannot choose the range by dragging the mouse from $E5:$13 (for
example). You will lose the range as the PT grows & shrinks. You must
select the range by selecting [your field name] value as the range.
1. Select [your field name] value range you want CondFormated. By moving
the cursor to the top edge of your field header [your field name]. Left
click, when you should see the cursor change to an arrow.
2. Conditional Formatting, New Rule (Do not go directly to the "Data Bar"
selection)
3. All cells showing "[your field name]" values for "[segment]" (option3).
Note: If you don't select the for "[segment]" option, the Data Bar will be
included in any Sub or Grand Totals.
4. Format all cells based on their values, Format Style (dropdown): "Data
Bar", OK.
Hopefully this helps.
