find and color the cells based criteria

[vranjit138]

Hi

I have data from Range E1: N25000 and i have a small list in Column Y from Y2:Y10

I need to search each value from Y2:Y10 in Range(E1:N25000) and if the value is found in the list . the cell has to be colored Yellow.

the list in Y column can increase or decrease


Please help

Kind regards
Ranjit

 

[bobsan42]

best to use conditional formatting with formula:
=CountIf($Y:$Y,E1)>0

 

[schielrn]

You could do this using conditional formatting:

Excel Workbook
	E	F	G	H	I	J	K	L
1	word
2
3								hello
4			word		hello
5						jake
6
7		list		joseph				hello
8					word
9
10						john
11			list	joe
1
2	list
3	kyle
4	word
5
6
7
8
9
10
11
Sheet1

Select columns E:N and input the conditional formatting of:

=ISNUMBER(MATCH(E1,$Y$2:$Y$10,0))

Hope that helps.

 

[schielrn]

list, kyle and word are actually in column Y, but not sure why my screen shot doesn't look that way?