Conditional Formatting in Pivot tables
 

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