conditional formatting the output

[#1]

I have some text as a header in a bar chart with an expression.
I would like for the result af the exp to change color if its over or under zero.

the expression is like this

left(sum(Gsnit2)-count(Journalnummer),4).

I tried something like this

if(left(sum(Gsnit2)-count(Journalnummer),4)<0,green,red)) but it doesnt work??

[#2]

Hi,

When specifying colours, you need to use (). i.e. Green() or Red().

I hope this helps.

Thanks

Nick

[brenner_martina]

Hi,

you must use tho function Green() resp. Red() or RGB(255,0,0) and so on

[#4]

I have tried like this

if(left(sum(Gsnit2)-count(Journalnummer),4)<0,green(),red())) but the output

come like this instead of the result RGB(0,128,0)) I want the number to be either red or green