How can I set conditional formatting properly?

[BernieSW]

When the value in cell C2 is {{item.numericvalue}}, I have tried using conditional formatting to make the background color different depending on the interval of the value.

like this
100 <= x < 150 red
151 <= y < 160 blue

So I added the following two conditional formatting to cell C2.
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue

And in the output after binding the list, there were 2 additional conditional messages attached to cell C2, resulting in a total of 4 formats.
like this
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue

Whenever I add conditional formatting, it seems to overlap and it takes longer to save. Is there any solution??

[efimov90]

Same problem, but probably if you add 1 more - you get 9 conditions
Actually if range of formatting can be expanded to current range of values it will be great.
Right now it cost too much.