Need to change the color of the Headers in Pivot table.

[alkesh_sharma]

Hi,

I need to change the format and color of the headers in a pivot table.

Neither I am  getting the option of 'Custom format cell' in the right click menu bar, nor I am getting the option of [custom] in the style Tab.

I am using 11.2 SR 7 Personal Edition.

Please Help...

[muniyandi · Accepted solution]

Hi

Setting-->  User Preference--> Design-->  always show design menu . tick the check box

Right Click in your pivot chart and  select custom cell format , now you can change background color, font color etc.

Thanks,

Muni

[#3]

Hi,

1.Turn On the Design grid.

2. Right clik on the cell you want to change the color.

3. Custom Cell format.

4. Change the background color.

Regards,

Joshmi

[alkesh_sharma]

Thanx Guys