Home » Posts

Highlight values not between X and Y

If you want to use conditional formatting to highlight cells that are NOT between two values (a lower and upper limit), you can use a simple formula that returns TRUE when a value meets that condition. For example, if you have numbers in the range B4:G11, and want to highlight cells with a numeric value not between 20 and 110, select B4:G11 and create a conditional formatting rule that uses this formula: =OR(B4upper) It's important that the formula be entered relative to the "active cell" in the selection, which is assumed to be B4 in this case. Also note that because we are using less than (

April 14, 2025 · 1 min · 74 words · Glenn Padilla

To make a more flexible, interactive conditional formatting rule, use other cells like variables in the formula.

You must use an absolute address for E2 and G2 to prevent these addresses from changing.

AND returns TRUEonly if all the conditions are met.

Excel formula: Highlight values between

If any conditions are not met, the AND function returns FALSE.

When given TRUE, NOT returns FALSE.

When given FALSE, NOT returns TRUE.

Excel AND function

Use the NOT function to reverse a logical value.

Excel NOT function