Conditional Formatting in Pivot Tables



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.

Shane Devenshire


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



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"

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.

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