Spreadsheet: 801509d1666237641-how-to-use-conditional-formatting-to-highlight-column-with-same-hd-use
Sheet: Sheet1

 |  |  |  | large b/c 2X3.. |  |  |  |  | order: t5vs..2X3 next & 0/1..all 0 like beow.3456(like t8(t9 below) than 6X3
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 7 | 6 | 6 | 8 | 8 | 11 |  | =LET(y,MAP(E3:S7,E4:[NAME]:S9,LAMBDA(a,b,c,IF(MAX(a,b,c)>1,TEXTJOIN(",",,a,b,c),""))),
 |  |  | all | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 8 | 6 | 6 | 9 | 9 | 12 |  | z,MAP(E$22:S$26,E$23:S$27,E$24:S$28,LAMBDA(a,b,c,TEXTJOIN(",",,a,b,c))),
 |  |  | [NAME]) | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 3 | 4 | 9 | 6 | 7 | 10 | 11 | 14 |  | t,MAP(y,z,LAMBDA(a,b,NOT(ISNA(MATCH(a,TOCOL(z),0))))),
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 2 | 4 | 5 | 11 | 10 | 9 | 16 | 15 | 19 |  | f,0=SEQUENCE(,COLUMNS(t)),g,MAP(VSTACK(t,f,f),VSTACK(f,f,t),VSTACK(f,t,f),LAMBDA(a,b,c,OR(a,b,c))),g)
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 3 | 4 | 6 | 12 | 13 | 12 | 21 | 19 | 26
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 6 | 13 | 16 | 15 | 28 | 22 | 32
 |  |  |  | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 7 | 14 | 17 | 17 | 30 | 26 | 36
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 3 | 2 | 4 | 4 | 6 |  | =LET(y,MAP(E3:S7,E4:[NAME]:S9,LAMBDA(a,b,c,IF(MAX(a,b,c)>1,TEXTJOIN(",",,a,b,c),""))),
 |  |  | all | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 4 | 4 | 3 | 5 | 5 | 7 |  | z,MAP(E$22:S$26,E$23:S$27,E$24:S$28,LAMBDA(a,b,c,TEXTJOIN(",",,a,b,c))),
 |  |  | [NAME]) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 5 | 5 | 7 | 7 | 9 |  | t,MAP(y,z,LAMBDA(a,b,NOT(ISNA(MATCH(a,TOCOL(z),0))))),
 |  |  | all(s/fexp) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 8 | 5 | 9 | 8 | 11 |  | f,0=SEQUENCE(,COLUMNS(t)),g,MAP(VSTACK(t,f,f),VSTACK(f,f,t),VSTACK(f,t,f),LAMBDA(a,b,c,OR(a,b,c))),g)
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 3 | 2 | 2 | 4 | 7 | 6 | 10 | 12 | 15 | 16 | 20
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  |  |  | EXCEL STUDY
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5 |  | =LET(y,MAP(E12:S16,E13:S17,E14:[NAME],b,c,IF(MAX(a,b,c)>1,TEXTJOIN(",",,a,b,c),""))),
 |  |  | all | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5 |  | x,MAP(E3:S7,E4:[NAME]:S9,LAMBDA(a,b,c,IF(MAX(a,b,c)>1,TEXTJOIN(",",,a,b,c),""))),
 |  |  | [NAME]) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 2 | 5 | 6 |  | z,MAP(E22:S26,E23:S27,E24:S28,LAMBDA(a,b,c,TEXTJOIN(",",,a,b,c))),
 |  |  | all(s/fexp) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 4 | 7 | 8 |  | t,MAP(x,y,z,LAMBDA(a,b,c,OR(NOT(ISNA(MATCH(c,TOCOL(y),0))),NOT(ISNA(MATCH(c,TOCOL(x),0)))))),
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 7 | 9 | 5 | 8 | 11 | 13 |  | f,0=SEQUENCE(,COLUMNS(t)),MAP(VSTACK(t,f,f),VSTACK(f,f,t),VSTACK(f,t,f),LAMBDA(a,b,c,OR(a,b,c))))
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18
 |  |  |  | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18