Finding number between range of numbers?

[elicoh]

Hello

i'm trying to locate a number between a range of numbers this way:
range of number for example 538000 - 538499. trying to locate the number 538125 that is the range of the numbers 538000 - 538499 and mark the cells with color. in addition to make things easier for me i names the cells and used conditional format rule
any suggestion ?

thanks eli

 

[Special-K99]

Why not just use Ctrl-F to find the number?

You need to specify clearly where the numbers are - are in they in a column? Which column? - are they in a row? Which row?
What cell are you storing the number to find (538125) in?