Conditional formatting not working for a field value

[pranlad]

Hello all, 

I have read all related post in community but didnt find answer. could someone help me to solve below problem.

I have used conditional formatting for GAP FTR% column based on field value. Even though the range is 90-100% its reflecting green font for 50% value as well. However the same formatting working perfect for Code FTR% column. 

Your help is appreciated.

[amitchandak · Accepted solution]

@pranlad , if it is a % column then it will be less than 1.

100 X 1

75 .75

[ibarrau · Accepted solution]

Hello, I always use "number" instead of "percentage". It doesn't work very well. You also have to change the values as Amit says as 1, 0.75, etc...

I hope that helps.

[amitchandak · Accepted solution]

@pranlad , if it is a % column then it will be less than 1.

100 X 1

75 .75

[pranlad]

@amitchandak @ibarrau , Thank you for your quick reply. The solution of changinf number to percent worked very well