Gauge chart color ranges and displayof "%" symbol

[#1]

hi

i am trying to display values as shown in the below image .

1. this is the percentage value that is been shown is there any way i could add the "%" symbol next to the value???

2. i have a similar chart just only showing the numbers(count).. is there any possible way to assign a color range??

ex: 1-100 green, 100-1000 orange and 1000 and above in red..

i want to display the values according to the color range is it possible???

would highly appreciate the help plz if some one knows how to get this done plz help me out plzz

thank you in advance

[#2 · Accepted solution]

The correct is:

if(sum(sal)<100,LightGreen(),if(sum(sal)) >1000,LightRed(),RGB(255,140,0)))