3 Replies Latest reply: Apr 4, 2012 4:33 AM by shah0786 RSS

    Conditional format

      Hello

       

      I have created a pivot table with two dimensions e.g department, pay level and some expressions e.g current permanant workforce, Temp, etc. Now I have dragged pay-level under the expression. What I am trying to do is formulate an IF statement so that each pay-level (the whole column say under Permanent staff) will be different colours. The following doesn't seem to work.

       

      if(perm_staff = 'Pay a', 'blue()', if(perm_staff = 'Pay b', 'Yellow ()'.....

       

      I have written this statement under background colour of Perm_staff.

       

      Please help

       

      Thanks