software

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.


You could use conditional formatting for the entire range. You would
simply compare the value in your target cell to the value in each cell
in the range. Format gt; Conditional Formatting

Cell Value Is: Equal to =$A$1

Then press the Format... button. On the Patterns tab, just click the
color you want for your hilite.

Hope this helps.--
BruceP
------------------------------------------------------------------------
BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
View this thread: www.excelforum.com/showthread...hreadid=542703One 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 Kquot;thoughtikneweverythingbutidontquot; oft.comgt; wrote in message
...
gt;I have a spreadsheet that contains many cells with the same number (it is a
gt; model number) and I want to highlight every cell in the sheet with that
gt; number. Is there a shortcut to doing it? Because of other format
gt; concerns,
gt; I can't do a sort first.