Conditional Formatting in Pivot tables

N

Natty

Hello,

I'd appreciate any help with the following issue.

I wonder if it's possible to apply the conditional formatting to a certain
fields of a pivot table in Excel 2003? Particularly, I created a calculated
field on my pivot table - Margin% (which uses the data from the other fileds
of the report), and I'd like to find and highlight those values in 'Total'
column which meet a certain criteria (e.g. where raw totals values (in %
format) are less then the grand total value).

I tried to select all raw totals with Ctrl+ button and then went to
Format->Conditional Formatting and put there 'Cell value is' less than
'reference to the cell with the Grand total', and clicked on format to choose
a pcolor pattern. but it didn't seem to work out properly.

Is there any way to do that?

thanks a lot in advance for all your comments.
 

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