Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change background color to a header in a Pivot Table, but only some columns header?
This columns are expressions and I need change background color in some columns header not in all.
For example, I have a Pivot Table like this:
Country | Sales | Cost |
---|---|---|
Mexico | 345,456,890 | 123,678,543 |
USA | 890,223,112 | 689,321,890 |
Japan | 789,478,900 | 567,908,145 |
And I need distinct background color in the columns header of the expressions (Sales in Yellow and Cost in Green) , like this:
Country | Sales | Cost |
---|---|---|
Mexico | 345,456,890 | 123,678,543 |
USA | 890,223,112 | 689,321,890 |
Japan | 789,478,900 | 567,908,145 |
How can I do it?
I need your help!!!
Thanks