Conditional Formatting in Pivot Tables


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

Shane Devenshire

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

Advertisements

A

AFSSkier

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

Advertisements

Joined
Jan 31, 2012
Messages
1
Reaction score
0
Thank you, thank you, thank you. This has bugged me for so long. Oh yeah, thanks again. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top