Try conditional formatting. Look up 'Highlight cells that meet specific
conditions' in the Answer
wizard in help

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lynn" wrote in message
...
Hi,
I have an excel spreadsheet which consists of columns names, phone nos.,
address, etc.
How can i automate excel to highlight those rows that consists of the list
of names in a text file?
thanks