Conditional format

[#1]

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

[CELAMBARASAN]

Hi,

     Change it to like this

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

Celambarasan

[#3]

Hi Celambarasan, I have already tried that and it does not work.

[#4]

Hi I think I've sorted it by changing perm_staff to 'Pay level'

Thanks all that had a look.