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.

      2013-02-04_133314.png

       

      Thank you all,

      Brian