This more precise expression removes the ambiguity between the two rules because they no longer overlap. Excel applies the green fill color only when the value is greater than 100 and less than 500.