formula not working in text box

[felcar2013]

hi

i don't really understand why this formula does not work in a text box:

=if($(%Change)>0,LightGreen(),LightRed())

%Change is a variable in percentage, that can be positve or negative

thanks for any help

felipe

[#2]

Try:

=if(%Change>0,LightGreen(),LightRed())

[felcar2013]

thanks

i get as result

RGB(255,0,0)

[#4]

That means you are entering it in the wrong place. Under General > Background > Color > Base Color > Calculated enter your expression. See attached.

[felcar2013]

thanks Rebecca, i forgot to say, i want that the variable value font changes the color accordingly, not the background. there is also an option under "font", but i get my result " RGB(255,0,0)" in the color i indicated, but what i need is to get the variable value in that color

is this possible?

[#6 · Accepted solution]

See attached.

[felcar2013]

excellent, thanks, it work however with the $(var)

[#8]

Ok good deal. Glad it worked for ya.