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.
