Can I use VBA to format every Pivotfield in a table that contains header P021 with a specific background colour
Posted on 2010-09-14
I have a Pivottable, that includes a number of columns with sales figures for different years. for each year I have an account in the Pivotcolumns called P021 that I would like to give a backgroundcolour that are for instance green.
But I am not able to give that column a background colour other than by formatting the individual cells.
How can I colour the whole Pivotcolumn in a green colour by VBA?