I am trying to build a routine to build a set of formulas to use in VBA to
loop through data and apply formatting

Basically I created an array 1st col = equation to evaluate and 2nd col =
formatting to be applied

Then I loop through the records trying to test the equation against that
row's value (in a specific col). I thought I had found the perfect function
for this using the Evaluate(), but it doesn't seem to be able to handle
slightly complicate equations and onlyreturns the proper value on the most
simple equations. Mine is set up as follows

Evaluate(Replace(aColor(0, m), "x", iLL)) = True

In which my equations can be of 2 types

x120
OR
80<x=119

for the first EValuate works just fine, but for the latter it does work???

What function would permit me to properly evaluate if my variable iLL meets
the second type of equation or not?

Thank you