Sub Total Colours

[#1]

Hi All

In my pivot table i have the subtotal background colours set to

=if (ROWNO() = 0, rgb(21,165,234))

For the field 'Variance' I have the text colour set to

=if (ROWNO() = 0, WHITE())

How do I amend it so that If the sub total for 'Variance' is <0 it is red.

Thank you for your help.

[anbu1984 · Accepted solution]

if(rowno()=0 or isNull(rowno())

  ,If(Variance>0,White(),Red())

)