Trouble With Conditional Formatting, Rows, and In-Betweens

[SpookyNoodle]

So, before we get too far into this, I should say: Yes, I have done searching for this, and no, I haven't found any tutorials, guides, or tips that are helping me sort this out.

I'm working on a spreadsheet (obviously), and I want to conditionally format the entire row based on the data found in one column at the end of the row. Obviously, I had to do custom rules and formulas to achieve this, which I found out after some searching.

The problem is this: nothing is working the way it's supposed to (as far as I can tell).

The rules I'm trying to achieve are this:

If the H value is between 0 and 1600, I'd like the entire row to be green.

If the H value is over 1600, I'd like the entire row to be yellow.

If the H value is below 0, I'd like the entire row to be red.

Problem is, no order I've tried as made this work, and the only thing is a multi-colored mess.

What am I doing wrong or missing?

 

[estevaoba]

Try these:

Green: =AND($H2>=0;$H2<=1600)
Yellow: =$H2>1600
Red: =$H2<0

In "Applies to", select the entire table for all three rules.

Godspeed!