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