10 Replies Latest reply: Dec 28, 2012 7:38 AM by Vishwaranjan Kumar RSS

    How can I change background color to a header in a Pivot Table?

    rocio trevino

      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:

       

      CountrySalesCost
      Mexico345,456,890123,678,543
      USA890,223,112689,321,890
      Japan789,478,900567,908,145

       

      And I need distinct background color in the columns header of the expressions (Sales in Yellow and Cost in Green) , like this:

       

      CountrySalesCost
      Mexico345,456,890123,678,543
      USA890,223,112689,321,890
      Japan789,478,900567,908,145

       

      How can I do it?

       

       

      I need your help!!!

       

      Thanks