On Feb 11, 12:21 am, Shane Devenshire
wrote:
Exactly what do you mean by "find"?

You could use conditional formatting but we need to know what your data
looks like. Suppose Column A on both sheets contains the unique site name,
then in the sheet with 250 names highlight column A and choose Insert, Name,
Define and give it a name (I will use Sites here)

Move to the second sheet and highlight the sites in column A. Choose
Format, Conditional Formatting, from the first drop down choose Formula is,
in the next box enter =OR(A1=Sites). Click Format, pick a color on the
Patterns tab and press OK twice.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"harveen" wrote:
hello,

i have a list of 1000sites in excel sheet 1....and there is a list of
250sites in excel sheet 2.....
i have to find these 250sites in that list of 1000sites..

please help..
i'll be very thankful

Regards
Harveen :)


hey, i have uploaded both files to the server.
please check them and could u please do it for me as i had asked. :)
and then upload to http://sendspace.com again. It will hardly take a
minute i guess.

here are the url's of both excel sheets:
http://www.sendspace.com/file/sg4250
http://www.sendspace.com/file/5fkmps

i need them urgently, so please can u do it....
thanks :(