Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting in pivot table
Hello !
Is there a way to conditionally format pivot table ??? What I have is the pivot table with few main dimensions and each of those has 2 subdimensions - I need to have all values in subdimension 'NP' in red - and corresponding row header - that would be great I'll draw a rough sketch below so there is less confusion region west east north south p np p np p np p np customer a b c d etc.... so I need customer name and value in column 'np' in red for all rows where column 'np' is not blank. This would be no problem in regular table, i used conditional formatting in source tab for this pivot but it does not help (it works only in source data) any suggestions greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting in pivot table
Hi
Assuming the PT is located in columns A through I Mark columns B:I, FormatConditional FormattingFormula is =MOD(COLUMN(B:I),3)=0) Mark column A Formula is = ISNUMBER(SUMPRODUCT((MOD(COLUMN(B:I),3)=0)*(B:I))) Set format to Red in both cases. -- Regards Roger Govier "shark102" wrote in message ... Hello ! Is there a way to conditionally format pivot table ??? What I have is the pivot table with few main dimensions and each of those has 2 subdimensions - I need to have all values in subdimension 'NP' in red - and corresponding row header - that would be great I'll draw a rough sketch below so there is less confusion region west east north south p np p np p np p np customer a b c d etc.... so I need customer name and value in column 'np' in red for all rows where column 'np' is not blank. This would be no problem in regular table, i used conditional formatting in source tab for this pivot but it does not help (it works only in source data) any suggestions greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions |