If condition for colour change in table

[#1]

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

[maxgro · Accepted solution]

add another if

if(QS >= 0.9, RGB(0,128,0),                         // >= 90 green

if(QS < 0.85, RGB(255,255,255),                // < 85 white

RGB(255,0,0)                                                  // >= 85 <90 red

))