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:
Well, not really. I want to know what the actual problem is (is it conditional formatting? Please confirm this)
--
Let's take the sample data you have shown in that last post. What's the desired outcome from that? (please show me)
If we take this matrix:
instead of the actual values I'd like to see percetanges... something like this:
| Business | Full | Selective | Idle | Total |
| Bu1 | 7% | 2% | 58 | |
| Bu2 | 100% | 11 | ||
| Bu3 | 100% | 11 | ||
| Bu4 | 41% | 1% | 58% | 71 |
As a business we have move don and are just using the numbers, but it would be nice to understand the solution if you still feel like having a look at this.