1. Select A5 on Sheet2.
2. Give it a name (Ctrl+F3) like "myname" (no quotes).
3. Select col. D of Sheet1.
4. Go to Format Conditional Formatting
5. Select "Formula Is" and put:
=COUNTIF($D1,"*"&myname&"*")
6. Press the Format button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
hi there,

i have a problem with Excel. can anyone tell me how can
I search a text of
cell in sheet2 in the cell range of sheet1.

suppose that the data in cell A5 of Sheet2 is Scott, and
on Sheet1 coulmn D
have a list of names, how can I find the Scott in this
case. Also I clear one
thing the list of names are unique there is no
duplications in it. so there
will be one and only one Scott.
.