8 Replies Latest reply: Apr 2, 2013 6:58 AM by Simon Goodman RSS

    IF AND Color Expression

    Simon Goodman

      I have a pivot table and I am trying to create an if statement with the Background Color of an expression where a value triggers a RGB color.

       

      My problem is one set of values is greater then say 60% but less then 80%  so it then applies a RGB. I have tried a number of IF AND expressions but I can not get it to work, very frustrating for what should be a simple if statement. Can any one help?