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 t...
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 _ Caitlyn