I need to prepare a conditional formula that will confirm or reject the data
in Column A to the data in Columns B and C as well as the range of numbers in
between B and C. Columns B and C are roughly twenty thousand lines and range
anywhere from 1 to 1000 numbers. For example:


Column A Column B Column C

473190044 491987100 491987199
511373007 491987200 491987299
542418053 491987300 491988300

Can excel search a range of 100-199 like in columns B and C or will all
numbers require a individual cell?