Column Header color changes in pivot Table.

[anuradhaa]

Hi,

I want to change column header color in my pivot table. But i don't know how to do it. Then i select current style and done some editing in custom format cells.

Some how it works but i know this is not the correct way?

I can't change column header raw in custom cell format and i only can change other raws.

Now i have another question,

in this attached picture there is a gray box and black lines, i need to change them.

please tell me how to change them.

Thanks

[alexandros17]

Right click on the poivot table, the select in the popup menu the item "Custom format cell" then use it to personalize cells

Hope it helps

P.S. if the voice is greyed then in document setting -> document properties -> general select styling mode -> advanced

[rustyfishbones]

Right Click in the Chart area of your pivot table and Choose Custom Format Cell

[anuradhaa]

No, that doesn't work.

Could you please tell how to change top raw using that settings. It doesn't work for top raw.

Thanks

[anuradhaa]

yes, i know we can do it using that, but that doesn't work for top raw.

Thanks for your reply

[rustyfishbones]

Check the Style Tab, maybe you have the Cell transparency set to 100%

[alexandros17]

Click on the header (in the cell you want to change, select the voice "Custom format cell" and use background color, it works ...

[anuradhaa]

No, It doesn't work for the top raw.

see attached,

[rustyfishbones]

It does not work because that's a dimension, not the top row

So in the Dimension, Click on the + button to change the background color

[#10]

It is working....please check again

You may have fixed color for particular expression or dimension in their background color...