How to use the IF command?

[#1]

Hello Dear All.

I have a problem using the command IF to color the background of a label object.

I would like to change the color of the background of a label when his values is changing.

Thansk is advance for your help

Regards

[#2 · Accepted solution]

=if(F1<0,RGB(255,0,0),if(F1=0,RGB(255,255,0),RGB(0,255,0)))

open properties for the text object and apply the formula for color. Replace 'F1' with the expression used for text object

[#3]

Ooooohhhh God. Thanks a lot dear Rakesh.

That was what I looked for

Here is the formula that i applied on my color :

=if(Only (TOT_AMOUNT)<0,RGB(255,0,0),if(Only (TOT_AMOUNT)=0,RGB(255,255,0),RGB(0,255,0)))

Thanks a lot to the team.

[#4]

what do you mean with apply the formula for color?? cause i just get the text output rgb(....)

regards

[#5]

hi kbs_tamm,

under base color, select 'calculated' and apply the formula

regards