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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tom" wrote:

> 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.

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.
--
Kevin


"Tom" wrote:

> 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.

[RJonesUSC]

Thank you, thank you, thank you. This has bugged me for so long. Oh yeah, thanks again.