Forum Discussion
Solved
Conditional Formatting not applying as expected when using Percentages
I have a matrix, it has Business Names as Row headers and a Status as Column Headings I cound the status per business like this and you can see that some have the same value in Full as in Total ...
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:
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: