Looking for a highlighting shortcut

  • Thread starter thoughtikneweverythingbutidont
  • Start date
T

thoughtikneweverythingbutidont

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.
 
B

BruceP

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.
 
B

Bill Kuunders

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"
 
Top