Conditional Formatting Pivot Table Excel 2007

M

MVarma

How do I apply the 3 arrow icon set under conditional formatting to work on
the entire pivot table and show the dollar amount change from column to
column but apply to each row?
 
A

AFSSkier

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.
 

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

Top