How to colours the cells if the conditions match

[motilulla]

Hello,</SPAN></SPAN>

I want to fill the colours in column W:AL numbers, if the are matched with column G:T; Please need help </SPAN></SPAN>

Example data</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1
2
3
4
5							n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14			n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	n15	n16
6							0	1	1	0	1	1	1	0	0	1	1	1	1	0			0	1
7							0	1	1	0	1	1	1	0	0	1	1	1	1	0			0	1	2
8							3	0	0	3	0	0	3	0	3	3	3	0	1	0			0	1	3
9							4	2	0	0	4	0	1	0	0	1	2	4	0	0			0	1	2	4
10							2	5	5	0	1	3	3	0	2	3	2	1	0	5			0	1	2	3	5
11							0	2	1	6	1	1	0	6	1	0	1	0	3	1			0	1	2	3	4	6
12							2	2	1	0	0	1	0	1	0	3	1	0	0	0			0	1	2	3	4	5	7
13							0	1	1	0	6	0	4	0	8	3	0	3	0	8			0	1	2	3	4	5	6	8
14							0	1	1	6	1	2	1	0	0	2	0	7	0	1			0	1	2	3	4	5	6	7	9
15							4	2	0	0	1	2	1	6	0	0	0	0	0	0			0	1	2	3	4	5	6	7	8	13	23
16							1	9	0	3	8	0	1	1	0	0	0	0	2	0			0	1	2	3	4	5	6	7	8	9	14	24
17							4	2	3	1	0	0	0	0	4	8	7	3	5	0			0	1	2	3	4	5	6	7	8	9	15	25
18							0	0	1	0	2	8	2	0	1	1	1	1	1	10			0	1	2	3	5	6	7	8	10	16	26
19							0	0	1	0	0	0	1	3	0	8	6	8	0	1			0	1	2	3	4	6	7	8	17	27
20							0	0	1	0	5	0	1	1	0	1	1	1	2	7			0	1	2	3	4	5	7	8	9	18	28
21							0	0	0	9	3	0	0	0	0	0	0	3	5	2			0	1	2	3	4	5	6	9	10	19	29
22							6	0	2	0	2	0	11	2	0	2	4	1	1	1			0	1	2	4	5	6	7	11	20	30
23							1	7	12	2	2	5	1	21	0	1	3	0	0	3			0	1	2	3	5	6	7	8	12	21	31
24							7	0	0	7	1	9	0	0	6	1	2	0	0	1			0	1	2	4	6	7	9	32
25							1	8	2	1	0	1	0	3	1	7	0	3	3	0			0	1	2	3	5	7	8	33
26							1	3	0	0	0	3	0	0	1	1	0	1	6	2			0	1	2	3	4	6	34
27							0	0	0	0	0	1	4	0	1	3	0	0	0	0			0	1	2	3	4	5	7	35
28							5	0	0	0	0	0	8	0	0	1	5	2	0	2			0	1	2	3	4	5	6	8	36
29							3	0	4	6	5	0	2	6	0	1	1	1	0	1			0	1	2	3	4	5	6	7	9	37
30							1	0	8	1	8	5	0	1	38	4	1	1	0	8			0	1	2	3	4	5	6	8	10	38
31							1	1	0	1	1	0	0	0	6	0	0	5	0	0			0	1	2	3	4	5	6	7	8	9	11	14	15	17	18
32							0	0	0	1	0	2	3	0	6	15	2	0	3	3			0	1	2	3	4	5	6	7	8	9	10	12	15	16	18	19
33							0	0	0	0	11	1	0	10	0	1	1	2	1	1			0	1	2	4	5	6	7	8	9	10	11	13	17	19	20
34							8	3	0	0	3	0	2	0	0	0	0	0	0	10			0	1	2	3	5	6	7	8	9	10	14	18	20	21
Sheet1

Thank you all</SPAN></SPAN>

Excel 2000</SPAN></SPAN>
Regards,</SPAN>
Moti</SPAN></SPAN>

 

[Fluff]

Not sure if 2000 is the same but in 2003 you can do that with conditional Formatting
Select W6:AL34, and in Conditional Format select FormulaIs & use this formula
=AND(W6<>"",COUNTIF($G6:$T6,W6)>0)

 

[motilulla]

Not sure if 2000 is the same but in 2003 you can do that with conditional Formatting
Select W6:AL34, and in Conditional Format select FormulaIs & use this formula
=AND(W6<>"",COUNTIF($G6:$T6,W6)>0)

Wow! Fluff, it worked spot on. Thank you so much</SPAN></SPAN>

Wish you a very Happy New Year 2019</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Moti </SPAN></SPAN>

 

[Fluff]

You're welcome & thanks for the feedback