How to make it display red when -ve and Green when +ve ?

[paulyeo11]

Hi All

I want to make the text color display red when the value is -ve and green color when +ve.

I have place the below expression at condition color   :-

if($(vSalesVariance) >0 ,'#46C646','#d01919')

But the color does not change. Hope some one can advise me where i go wrong ?

Paul

[paulyeo11]

qvf

[sunny_talwar]

May be try with RGB()

If($(vSalesVariance) >0 , RGB(70, 198, 70), RGB(208, 25, 25))

[paulyeo11]

Hi Sunny

I have try , but the text color never change .

Paul

[sunny_talwar]

It seems that you are using an extension? Is that true? I won't be of much help if that is true

[paulyeo11]

Hi Sunny

I am not using extension.

Paul

[sunny_talwar]

Can you point out which object are you trying this on?

[paulyeo11]

Hi sunny

[sunny_talwar]

Those button seems to be using extension because I am unable to view those buttons

[paulyeo11]

Hi Sunny

Yes i use extension , that is 2 button for select field value . to make the value display +ve and -ve.

By the why , Can you make the 15.3 change from black to Green ?

Paul