8 Replies Latest reply: Feb 4, 2013 3:58 PM by Brian Garside RSS

    Pivot-table background color issues...

      I have a pivot table with Background expressions. I would like to prevent the color 'bleeding' into the Dimension columns below

      I tried the right click 'Custom Format Cell' option but no luck. It simply is overidden by the expression!


      Option 1

      If(Technical='G',LightGreen(),If(Technical='R',LightRed(),If(Technical='Y',Yellow(255),White() )))

      I changed the order of the white color fucntion but no change.


      Option 2

      If(Costs='Costs',White(),If(Costs='G',LightGreen(),If(Costs='R',LightRed(),If(Costs='Y',Yellow(255) ))))


      The area highlighted in red is the area of concern.



      Thank you all,