Conditionally colour the headings in a pivot table

[#1]

I have a pivot chart and wish to colour te headings differently for each expression. I would have liked to colour the toatl line independantly but this does not seem possible.I hav tried if(rowno() = 0) with the sub totals at the top but then I am unable to suppress the zero lines in the table.

I have an if(column(1)<>0,... in each expression

[sbaldwin]

Hi, you should be able to colour the headers by going to visual ques, select the expression you want then at the bottom of the screen there should be a Text line which you can then change to be any colour you want.

as for colouring the totals differently have you tried going to the expressions tab expanding the required expression, selecting background colour and putting in something like this:

=if(sum(TOTAL Expression1) = sum(Expression1),rgb(255,0,0))

Thanks

Steve

[#3]

I tried both with no success - I will keep experimenting