Header of straight/pivot table

[tyagishaila]

Hi,

Is there any possibility in QV to change only header's background/text color in Straight/pivot table?

Don't want to change whole expression's background/text color.

I have attached an image as per my need.

Thanks,

[Anonymous · Accepted solution]

Go to User Preferences Design tab and check the option for 'Always Show Design Menu Items'

Then right click on the header cell of the pivot/straight table and choose Custom Format Cell option. You can change the background color here.

[awhitfield]

Be aware that this will change the colour of all the header rows

[tyagishaila]

Thanks Greeshma for quick reply.

Its working, but can I apply different colors on different cells.

Under Customer Format Cells --> Apply Change to -->

there is always only option available All Dimensions

your Suggestion is really appreciable,

Thanks again

[tyagishaila]

Yes I checked,

Is there any possibility to apply different colors in different cells.

Plz suggest.

Thanks

[Anonymous]

Hi Shaila,

I don't think that is possible.

[tyagishaila]

Okay,

Thanks Greeshma

[awhitfield]

Hi Shaila,

you could always create a semi transparent text box with the required colour and position this over the top of your header cell, see the attached example.

Andy

[tyagishaila]

Hi Andrew,

Actually it will not work with my pivot table, because it is customized table.

any ways,

Thanks, you spend your precious time to solve my problem

[buzzy996]

may be tis helps,

Two things u could be do for this,

1. Settings menu--User preferences--Design tan--click the check box "Always show the design Menu Items"

2.Right click on column(for whichever column u need format)--select "Custom format cell".