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

[anuradhaa]

Thanks,

But problem i have is The "Gray Box". That is empty. also i don't know how to remove borders.

[#3]

I'm having the same issue, and Anuradha is correct, it is not resolved using neither Custom Format Cell nor Dimension Background Color.

Here's my own example, attached.

[anilet123]

Hi,

Whether the issue fixed ? I am also facing the same problem & above solutions are not working. can anyone provide the right approach pls ..

Regards,

Anilet

[settu_periasamy]

Hi,

i think, we can't cant change that color in pivot table (because your dimension moved to the row)

May be you can try with Cell Background Transparency as 100% in Style tab.

or

Create the text box,give the color, put this in the top left position of your pivot table.

Change color in pivot table header area

[Digvijay_Singh]

Not sure but I found that I could change color of all sections of pivot table using Custom format cell. See the image below-