Forum Discussion
Conditional Formatting not applying as expected when using Percentages
It's quite a common misunderstanding this one. You can search the forum for solved similar issues.
Using 'percent' in conditional formatting is not about the data type, it's about
"the rule boundaries as a percent of the overall range of values" which you don't want in this case.
Use a different rule type as here:
You have a reasonable point about the solution being accepted. It was done by one of the community support team and we don't have any control over that. I'm not too harsh on this type of behaviour because they have a job to do and we superusers are just dabblers.
Ok, to the problem itself - the link shows how to use conditional formatting when your values are in percent datatype. I'm open to you telling me it doesn't work for you. Tell me what happened when you implemented the suggested solution and why it doesn't fit your use case and i will attempt to help.