1 Reply Latest reply: Dec 2, 2014 6:13 AM by anbu cheliyan RSS

    Sub Total Colours

      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.