How to make Guage Red when < 0 % and Green color when > 0 % ?

[Paulyeo11]

Hi All

[Anonymous]

hi @Paulyeo11 ,

Go to format tab and then expand the Data Colors Section-

Click on "fx", highlighted above, and then a new window will open where you set the values for minimun and maxium and the color what you want, ie. green and red accordingly.

[amitchandak · Accepted solution]

@Paulyeo11 , Under data color in the format, I fill click on FX. And define rule

-1 to 0 red (If column is % else -100 to 0)

>0 to 1 (green)