Change background cell color in the chart table

[#1]

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

[sergio0592]

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

];

[quiquehm]

Thank you Jean ! I tried it and it works perfect !

rgds

Enrique