5 Replies Latest reply: May 12, 2017 5:11 AM by PAUL YEO RSS

    Why variance cell not change to red ?

    PAUL YEO

      Hi All

       

      I have a expression below :-

       

      column(2) - column(1)

       

       

      I need to make the black ground color change to red when the value is -ve.

       

      So i create below expression :-

       

       

      if((

       

      SUM(

       

      column(2) - column(1)

       

      )

      )<0,RED())

       

      But the balck ground color does not change to red. Where go wrong ?

       

       

      Paul Yeo