CODEWITHSUNDEEP
excelgoogle-sheetsconditional-formatting
krexaim
krexaim

Reputation: 13

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

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.

Upvotes: 1

Views: 33

Answers (1)

Dominique
Dominique

Reputation: 17493

Just combine these two basic rules:

enter image description here

Into something like:

enter image description here

It comes down to:

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

It results into this:

enter image description here

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

Upvotes: 1

Related Questions