One way,

select the range with the numbers.

format
conditional formatting
is equal to
point to a cell outside of the range (say it is K1)
select your format.
enter the model number in cell K1
--
Greetings from New Zealand
Bill K


"thoughtikneweverythingbutidont"
oft.com wrote in message
...
I have a spreadsheet that contains many cells with the same number (it is a
model number) and I want to highlight every cell in the sheet with that
number. Is there a shortcut to doing it? Because of other format
concerns,
I can't do a sort first.