Hello,

I suggest conditional formats on both the boundary cells and the third
cell.
Highlight third cell's background green if its value is within
boundaries.
Highlight a boundary cell's background red if third cell exceeds its
limit.

HTH,
Bernd