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