I am having this error where I am trying to color Bar colors by percentage and in the conditional formatting, I am creating a Rule for different colors above and below a certain percentage. However there seems to be a bug where it doesnt exactly work the way it is supposed to :Attached are pictures of the issue. Just wondering if this can be investigated
goes green before my target 30% value as mentioned in Conditional formatting Rule
2 Comments
Hi abhisub ,
You wrote the wrong rule when you set the background color.
If the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values; for example, ".30" instead of "30". Also, select Number instead of Percent for the number format. For example, "If value is greater than or equal to 0 Number and is less than .30 Number" returns values less than 30%.
A demo for your reference：
For more information，you can refer to：Color by rules for percentages
Best Regards,
Community Support Team _ CaitlynThanks a ton Anonymous ! i thought type conversion to percentage for fields would sync with the percentage here. But this works for me
