Hi
- define a name for D1:D100 on sheet 1 (menu 'Insert - Name - Define). e.g.
call this name 'sourcelist'
- select A5 on sheet 2
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF(sourcelist,A5)
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany
"Saadi" schrieb im Newsbeitrag
...
I want to change the color of found text in Sheet1. Like if A name "Scott"
is
founded in Sheet1 then its color in sheet 1 will be RED

"Frank Kabel" wrote:

Hi
what do you want to do with the '*found value'

--
Regards
Frank Kabel
Frankfurt, Germany
"ShareerIslamabadiMunda"
m
schrieb im Newsbeitrag
...
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.