Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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())
Ok thank you, but i was speaking about something like this
Did you understand?I dont know if i was clear
See attached example.
Thank you