find cells with values that fall between dynamic start and end value, color offset (-1,0)

[ThaGonz]

Hello and thanks in advance for any help with this scenario!

I am looking to search a specific cell range for values that are equal to or fall between a dynamic start and end value and color the offset row cell (-1,0) red.


Sample sheet also attached with clearer instructions

[millz]

Try the attached

[ThaGonz]

Awesome...Thank you so much for the quick response! This is just what i needed. This is solved!