Looking for a highlighting shortcut
 

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.

Looking for a highlighting shortcut
 

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 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: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=542703

Looking for a highlighting shortcut
 

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.