As I'm not sure if I was understood correctly (probably partially), that's why i constructed this awesome excel example of what I mean:

Measure1 conditional formatting is what I have now

Measure3 to the right is what I want to achieve

So I want to use conditional formatting (not discrete!) dividing it per GROUP or any other category I might have. so this formatting is set separately for group A, B and C.

In example Measure1 you can see that it's just one conditional formatting and number 1 has most red color, number 75 has most green color.

In Measure3 example this is different. For group A number 1 is red, 60 is green, but in group B, as the lowest nubmer is 50 - this number is red, and 52 as a max - is green.

Thanks in advance!

PS - i cant use pivot tables and I must have this dynamic, not choosing colors for each number separately

Wow, this really is a workaround haha..

It works! Thanks. One more question - how to change values to percentage while they are a text value?

I have few metrics, lets say one is Clicks and one some kind of aggregation like clicks / impressions, so I wanna show the second metric as a % format and not numeric