Search For Value

  • Thread starter Thread starter JAgger1
  • Start date Start date
J

JAgger1

I have spreadsheet with 1200 data points, I would like to search
these data points for certain value and have this value highlighted,
usually the value(s) I search for occur more than once, it just takes
forever to manually search and I always have to double check to make
sure I didn't miss any . Is there a way to do this? Thanks
 
Edit>Find

What: your certain value>Find All

In the Found Dialog box hold SHIFT key and scroll down to bottom of dialog box
and select last found cell.

Those points will be selected on your sheet.

Format>Cells>Pattern. Pick a color and OK.


Gord Dibben MS Excel MVP
 
Hi Jagger,

Another way may be to use conditional formatting.
Say your data points are in A1 to A1200.

Highlight A1:A1200
Go to Format>Conditional Formatting
Set formula is =A1=$B$1
Click format and select a color from the Patterns tab
And OK out
Now whatever value you put in B1 will be highlighted
in column A.

You can also put this in C1
=COUNTIF(A1:A1200,B1)
And it will count them for you.

HTH
Martin
 
Try conditional formatting looking for cells that = the value you are
looking for and highlighting cells that meet the criteria.
 
Back
Top