If condition for colour change in table

Tue, 25 Aug 2015 06:48:24 GMT

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

Re: If condition for colour change in table

maxgro — Tue, 25 Aug 2015 07:04:21 GMT

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

))