Trying to highlight cells based on other cells, row by row

Question

I'm trying to use conditional formatting so that the cells in green will highlight when they are NOT BETWEEN the values in the cells in orange, on a row by row basis. Seems like conditional formatting doesn't accept taking values from other cells when defining the rule and only accepts values or formulas. And if possible, a way to apply the rule down the list similar to filling formulas.

Answer 1

Just combine these two basic rules:

Into something like:

It comes down to:

A is not between B and C <=> (A<B) OR (A>C)

It results into this:

Both the values 1 and 5 are not in between of 2 and 4.