Create an Excel defined name for the range on Sheet2, say s2data, and then
use Conditional Formatting on the range on Sheet1 with a formula of

=ISNUMBER(MATCH(A1,s2Data,0))

and set the colour to suit.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Vadhimoo" wrote in message
...
Hi ,
I am having two sheets like:

Sheet1:
John
Michael
Legault
David
.......

Sheet2:
David
Eric
John
Dave
.......

Here i want to compare the Sheet1 's data with Sheets2's data. If the data
match, i want to set the background color(yellow or red) for those datas
in
the Sheet1.
Result:
Sheet1:
John(Set Background Color)
Michael
Legault
David(Set Backlground Color)
.......

Thanks and Regards,
Vadhimoo