Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables & Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting in pivot tables based on another column | Excel Discussion (Misc queries) | |||
Excel 2007 - Conditional Formatting applied to Pivot Tables | Excel Discussion (Misc queries) | |||
Conditional Formatting and pivot tables. | Excel Discussion (Misc queries) | |||
Conditional formatting in pivot tables? | Excel Discussion (Misc queries) |