Compare Ranges

[Pirvu Vali]

He guys, I attached an example. How can to make reference to more ranges?

[Keebellah]

Hi, why don't you explain a little bit more or doe we have to download the file to see what you mean ?

[Pirvu Vali]

download the file, please

[Keebellah]

Maybe this ?
You question still is not clear but maybe this is what you mean.

Change the value in the diameter of change the f7 to see

[Pirvu Vali]

i want to color every cells (C2:L12) with red is the value is < 3, with green if the value is <3 and <=6, and with yellow if the value is > 6.

[Keebellah]

Then you ask that, that was not mentioned in the file.
But, you have this rule now all you need to do is add the three other rules vor the exceptions.

[Pirvu Vali]

is not working to reffer to Range("B2:L12")

[Keebellah]

NO it will not work referring to B2:L12, you asked for C2:L12

If the answer is not correct then you should evaluate the question first.
A correct answer can only be given if the question has been correctly formulated

[Pirvu Vali]

yes, C2:L12

[Keebellah]

Well, did you check and test the attached file?

[Pirvu Vali]

yes, is not ok. in every cell i want to collor. for example, in a row, if A2 = 4 and C2 = 3, D2 = 8, E2 = 5, AND MY INTERVAL IS (3-6), THEN C2 COLLOR = RED, E2 = GREEN, D2 = YELLOW

[Keebellah]

That was not what you said in your question. The questions as you stated it was answered but ...
So:
you see the conditional formatting rules I wrote, you can adapt them.
Other option.
Upload the file again without the formatting and below the same table colored manually with the conditions you want.
Then I will look.

[Pirvu Vali]

i upload the new file

[Keebellah]

YOU could have done this yourself, if you had made at least some effort to see what I had earlier attached, this is exactly the same except that you specified different conditions.