If this bothers you, feel free to subtract 1.

This number is then compared to the value from “input”.

For example, =MID(“apple”,2,3) returns “ppl”.

Excel formula: Highlight values greater than

Excel formula: Highlight values between

Excel ISNUMBER function

Excel MID function