(Below) I have 2 columns. Column 1, row 1 contains the minimum and column 2,
row 1 contains the Maximum. I want to be able to enter a number (say 55) and
it will search for that number within these ranges and highlight it with
either text or a colour (color).
I would prefer it to be simple (ie.a formula). Would appreciate your help as
it has got me baffled. Thanks.

1 50
51 100
101 150
151 160

Enter Number: 55


--
All help is greatl appreciated and bless those with the knowledge