1 Reply Latest reply: Aug 25, 2015 3:04 AM by Massimo Grossi RSS

    If condition for colour change in table

    Hasvine Dhurmea

      Hello All,

       

      I am trying to create an expression for colours which I am able to do for two colours but I need 3 colour change.

       

      That is:

      I need the colour to be green when my QS is >= 90RGB(0,128,0)

      and red when it is below 90 RGB(255,0,0)

      and white when it is below 85 RGB(255,255,255).

       

      I am using the if statement for like

      =If(QS>='90%', RGB(0,128,0),(255,0,0))

       

      However, I cannot find a way to integrate the third condition and the third colour in my expression.

       

      Thanks,

       

      Hasvine