If ElseIF Statements + And

Hello Sif,

Thank you for your question. The AND and the OR functions are really meant to use in your IF or ELSEIF lines, to run more than one test on a cell. If you want to apply more than one action on a condition, rather write these expressions on separate lines.

I would suggest:

If rngTrim > highPTile Then
rngTrim.Value = newHigh
rngTrim.Interior.ColorIndex = 37

ElseIf rngTrim < lowPTile Then
rngTrim.Value = newLow

End If

I hope this works.

Kind regards
Marius Barnard
Best STL