Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Colour Banding in pivot tables
Hi all,
Is it possible to do colour banding in pivot tables? I have searched all avaible AutoFormat and I could find none, nor could I do it using conditional formatting. Thanks a lot. Frederick Chow Hong Kong. |
#2
|
|||
|
|||
Frederick,
My Excel add-in "Shade Data Rows" seems to work on Pivot tables. I just tried it out on a pivot table as have never had the need. It shades groups of like valued rows or by every nth row. Does the selection width or the entire sheet width. Choice of colors and an option to skip hidden rows. Comes with a one page Word.doc install/use file. Free upon direct request. Remove XXX from my email address Regards, Jim Cone San Francisco, USA XX "Frederick Chow" wrote in message ... Hi all, Is it possible to do colour banding in pivot tables? I have searched all avaible AutoFormat and I could find none, nor could I do it using conditional formatting. Thanks a lot. Frederick Chow Hong Kong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |