Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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
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.
what do you mean with apply the formula for color?? cause i just get the text output rgb(....)
regards
hi kbs_tamm,
under base color, select 'calculated' and apply the formula
regards