Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression to change background color of a cell on
=If([Technology Status]='AAA',lightgreen()) -
works fine but I do have multiple statuses so I want to color them in different colors.
Such as:
=If([Technology Status]='XYZ',lightblue()) and
=If([Technology Status]='xxx',red()) and so on
How do I use nested if or is there any better way? Thanks, yury
Hi Enrique,
You must write the name of the color field. In my exemple below, the name of the field color is JudgColor.
JudgmentsColors:
LOAD *
,rgb(R,G,B) as JudgColor
INLINE [
Judgments,R,G,B
critical,255,28,28
major, 255,255,45
minor,0,128,255
];
Thank you Jean ! I tried it and it works perfect !
rgds
Enrique