Formatting with 5 conditions

Good afternoon,

I am trying to format the background of cells depending on their values.
To simplify, I'd like to change the background colour of the cell to:
- Dark blue if the value of the cell is less than 100
- Light blue if the value of the cell is between 100 and 0.
- Green is the value is between 0 and 100.
- Orange of the value is between 100 and 200.
- Red if the value is greater than 200.

Although I understand how I would do it with an "IF" function, I am having some problem with the conditional formatting. I have also thought about do it with VBA but would prefer start with Excel conditional formatting first.

In reality, I am looking for a VLOOKUP value in a different page as set value and also would need to apply an "AND" function to make sure this VLOOKUP value is enabled (marked with a "T"), such that a true statement would be:
IF(AND(VLOOKUP("Tag",limits,13)="T", A4>VLOOKUP("Tag",limits,12))) then change the background colour in red.
limits being the table where I take the VLOOKUP value from.
Which is also giving me some errors...

Can you please give me some guidance and the best way to replicate this conditional formatting to 100s of cells.

Thank you,
J