Indicators with strings

[#1]

Hi.

I have this expression

if(Number1  <0, 'OK',

if(Number2< 31, 'Not Ok', 'OK2'))

Now i wanna do this with an traffic light indicator? i dont know how to say this in english.

is like the blue or red light

if OK = red

etc...

how i do this? it works with numbers but it doesn't work with strings.

Thank ya!

[Gysbert_Wassenaar]

Click on the + sign in front of the expression and select Background Color. Then enter an expression to calculate a color. Something like =pick(match(MyField,'Ok','Not Ok','OK2'),lightgreen(),lightred(),lightblue())

[#3]

Ok thank you, but i was speaking about something like this

[#4]

Did you understand?I dont know if i was clear

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#6]

Thank you