Pivot table - colour of headers

E

eeelllaaa

Hi,
maybe someone could help me - I have a pivot table which source data changes
very often.
It's something like this:
----------------------------------------
| city1 | city2 |
------------------------------
| item1 | item2| item3 | item4|
----------------------------------------
names .. .. .. .

Cities are often the same, but number of items can be different, depends of
period. The headers of table have to be coloured (only headers, not cells wi
th data), for example: "city1" and it's "items" should be blue, and "city2"
and it's "item" -yellow. But when the source data change and there are some
new items, the headers are not formatted.
I would like to do this automatically, with some macro. What properties or m
ethods of PivotTable should I use?

Thanks,
Ela
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top