Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
Be aware that this will change the colour of all the header rows
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
Yes I checked,
Is there any possibility to apply different colors in different cells.
Plz suggest.
Thanks
Hi Shaila,
I don't think that is possible.
Okay,
Thanks Greeshma
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
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
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".