Forum Discussion
Conditional formatting not working for a field value
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.
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.
3 Replies
- amitchandakSuper User
- pranladNew Member
@amitchandak @ibarrau , Thank you for your quick reply. The solution of changinf number to percent worked very well
- ibarrauSuper User
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.