header row background color in pivot table

[sonikajain]

Hi all,

Please advise on changing the background color and formatting to BOLD for header row in a pivot table.

Sonika

[mphekin12]

Sonika,

Go to the 'Visual Cues' tab of the Properties of the Pivot Table and check the 'Bold' check box and change the Background Color in the 'Text' row.  You will need to do this for each expression in the Pivot Table.

I hope this helps!

[vincent_ardiet · Accepted solution]

Hi Sonika,

First go to the User Preferences, and choose "Always Show Design Menu Items" in the Design tab.

Then, if you right click on your header, you will have the "Custom Format Cell" entry in the contextual menu.

You will be abble to fine tune the colors of your cells.

Regards,

Vincent

[#4]

Hi Sonika,

You can also go to properties of the chart and expand all dimensions and expression and then write Expression to change  Background Color, Text format, Text color if you are not able to fulfill your requirement with the solution give by Vincent.

Hope this help,

Anosh

[sonikajain]

thanks , it worked from the design pane

[#6]

Need to populate one list box depending upon the selection of other ? Can anyone help on this ?