Conditional Formatting in Pivot Tables

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

When I set conditional formatting in data columns of a pivot table in EXCEL
2007, the formatting is lost when the pivot table is refreshed.
 
Hi,

A known bug I have reported to Micorost in the past, lets see if it gets
fixed.
By the way it doesn't happen to all conditional formatting.
 
Tom,

If you're using Excel 2007, the key to Conditional Formatting in Pivot
Tables is 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.
 
Back
Top