Matching Multiple Instances of Letters Based on a 2-Row Cell Reference

[njpamdnc]

Hello...For the past several hours I have been trying my best to discover a way to simply have Excel look at A1:I2, and HIGHLIGHT all of the matching values throughout the larger bottom 3 grids although you can only see 2 of them due to the fact my screenshot could not include the 3rd grid. The range for Grid 1 is A5:K15. The range for Grid 2 is A18:K28. Finally, the range for Grid 3 is A31:K35. I studied conditional formatting and VBA with Google and YouTube, but I have not had success due to so many formula errors. Any assistance you can provide will be greatly appreciated.

Thanks,
Robert

 

[kevin9999]

Conditional formatting

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	X	S	A	T	G	L	M	123	2
2	3	U	P	O	F	Q	N	Y	F
3
4
5	A
6			E	S			Q
7							R
8							T
9	V			X			Y
10							U	I
11		E								E
12
13			Q
14					Q
15								Q	Q	Q
16
17
18
19
20			123
21								G	H	J
22
23						Z
24
25									X	Y	Z
26			U
27			X
28
29
30
31
32	A										V
33	B					123					S
34	C					1					W
35	D					2					X
36	E					3
37	F
38	G						Q	R	D	T
39	H
40
41
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A31:K41	Expression	=COUNTIF($A$1:$I$2,A31)>0	text	NO
A18:K28	Expression	=COUNTIF($A$1:$I$2,A18)>0	text	NO
A5:K15	Expression	=COUNTIF($A$1:$I$2,A5)>0	text	NO

 

[njpamdnc]

Ok...Do I enter all three COUNTIF formulas as one formula using Conditional Formatting? The graphic you made for me is exactly what I want. However, I am not sure how to correctly enter the data. Could you please show me exactly how I need to enter the data within Conditional Formatting?

 

[kevin9999]

Ok...Do I enter all three COUNTIF formulas as one formula using Conditional Formatting? The graphic you made for me is exactly what I want. However, I am not sure how to correctly enter the data. Could you please show me exactly how I need to enter the data within Conditional Formatting?

Hopefully this will show you how

 

[njpamdnc]

Thank You!!!