Highlight Adjacent Cells in a grid

[JLEMS]

Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get it done. I have a 10X10 grid of random numbers. What I want to happen is I want a formula encompassing the entire grid, and highlight only the cells that are adjacent to each other if all 3 numbers are there. For example, I included a smaller scale image. I have a grid of numbers and only want the 312 to highlight, but only if the cells are adjacent to each other. I don't want it to highlight all the 3's 1's and 2's. Only if all 3 are there.

Think of it like a wordsearch puzzle. Does this make any sense and can anyone help?

Thanks

 

[JLEMS]

That is almost right! Instead of the numbers being a set 1,2,3 the 3 digits will come from a reference of another cell. O3, O4, O5

 

[JLEMS]

I am wanting to have the formula apply to B2:M13,C15:G21 and the reference to be O3,O4,O5

 

[shaowu459]

I am wanting to have the formula apply to B2:M13,C15:G21 and the reference to be O3,O4,O5
View attachment 14941

MrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		GRID
2		3	3	6	2	7	9	1	8	0	1	9	9		Prv.
3		8	4	5	0	1	7	6	9	1	4	6	9		1
4		6	9	2	5	1	0	9	4	8	5	9	6		3
5		7	6	1	3	7	0	6	9	7	6	9	9		2
6		0	5	3	2	6	9	9	9	3	7	8	9
7		2	8	3	1	7	8	3	7	9	2	8	2
8		2	5	4	2	2	4	1	6	3	5	9	9
9		5	7	8	0	8	9	6	4	2	6	1	1
10		4	3	9	9	7	6	6	8	3	3	9	0
11		3	9	6	4	2	8	6	5	1	5	8	4
12		0	8	6	9	3	4	3	3	2	1	5	2
13		3	5	2	3	4	0	9	0	5	1	1	9
14
15			7	2	8	1	8
16			9	8	2	6	3
17			0	4	5	2	1
18			7	1	2	6	8
19			7	4	9	1	3
20			2	8	0	6	6
21			4	6	2	4	6
Final

Cell Formulas
Range	Formula
B2:M13,C15:G21	B2	=RANDBETWEEN(0,9)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C15:G21	Expression	=OR(C15=$O$3,C15=$O$4,C15=$O$5)*COUNT(0/COUNTIF(OFFSET(C15,-1,-1,3,3),$O$3:$O$5))=3	text	NO
C15:G21	Expression	=(C15=$O$5)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$4)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$3),0))	text	NO
C15:G21	Expression	=(C15=$O$5)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$3)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$4),0))	text	NO
C15:G21	Expression	=(C15=$O$4)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$5)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$3),0))	text	NO
C15:G21	Expression	=(C15=$O$4)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$3)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$5),0))	text	NO
C15:G21	Expression	=(C15=$O$3)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$5)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$4),0))	text	NO
C15:G21	Expression	=(C15=$O$3)*OR(IFERROR((OFFSET(C15,-1,-1,3,3)=$O$4)*COUNTIF(OFFSET(C15,OR,OC,3,3),$O$5),0))	text	NO
B2:M13	Expression	=OR(B2=$O$3,B2=$O$4,B2=$O$5)*COUNT(0/COUNTIF(OFFSET(B2,-1,-1,3,3),$O$3:$O$5))=3	text	NO
B2:M13	Expression	=(B2=$O$5)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$4)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$3),0))	text	NO
B2:M13	Expression	=(B2=$O$5)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$3)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$4),0))	text	NO
B2:M13	Expression	=(B2=$O$4)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$5)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$3),0))	text	NO
B2:M13	Expression	=(B2=$O$4)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$3)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$5),0))	text	NO
B2:M13	Expression	=(B2=$O$3)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$5)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$4),0))	text	NO
B2:M13	Expression	=(B2=$O$3)*OR(IFERROR((OFFSET(B2,-1,-1,3,3)=$O$4)*COUNTIF(OFFSET(B2,OR,OC,3,3),$O$5),0))	text	NO

 

[JLEMS]

Oh I see now. I think that will cover it! Thanks