You could use conditional format for this...

Set a cell as the "key" and format cells if they equal the key value.

This should help you see how to make this work.
http://www.contextures.com/xlCondFormat02.html

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"darnduk" wrote:

I have spreadsheets from several Field Service Engineers with serial numbers
and other information. I want to select a column of serial numbers from
these spreadsheets, find and highlight those serial numbers in my workbook.
Doing one serial number at a time is tedious. Is there a way to get Excel to
do several at a time?