Conditional formatting

[Rock5150]

I have a spreadsheet that contains net golf scores with different partners. I want to know if there is a way if i enter names as listed in the spreadsheet by pairing if it can color code the cell in yellow. I would enter the names in two columns A and B in a separate tab. Then somehow only highlight the scores where there is two partners listed in the separate tab. I attached the spreadsheet here however i can't remember that there was a unique way to attach docs in this forum. The area needing highlighting if the pairs are listed is column X to CT.

I used the add in and only copies a portion. If there is a formula or conditional formatting then i can copy and apply to rest of cells.

And to apply a conditional formatting and copy to other cells, its format painter correct? if there is a fast way to copy conditional formatting to other cells quickly let me know.

The goal is once i get the scores highlighted i can then take it from there and pick the MIN score for the winner.

	Alston James	Anderson Eric	Archuleta Michael	Baker Bea	Bledsoe Darryl	Bolden Anthony	Booker Richard	Bowie Anthony	Brister Antonio	Brown Kendall	Carter Melvin	Carter Rick	Clayton Royal	Colebrook James	Colebrook Sean	Crawford Pat	Davis Murry	Diamond Lorenzo	Diaz Mario	Dubose Damitoin	Edmonds Scott	Evans Booker	Gardner Mary
Alston James		64	67	71	71	65	66	68	66	70	66	66	64	67	67	65	67	75	67	72	71	67	68
Anderson Eric	64		66	63	65	61	64	66	63	64	61	63	60	64	64	61	64	67	63	66	65	62	63
Archuleta Michael	67	66		65	67	63	63	69	63	66	63	62	62	66	65	63	66	71	63	67	67	63	66
Baker Bea	71	63	65		69	64	66	69	65	66	63	64	62	66	65	65	67	72	66	68	66	68	68
Bledsoe Darryl	71	65	67	69		64	67	73	67	69	64	67	64	69	67	65	68	77	69	71	73	67	70
Bolden Anthony	65	61	63	64	64		62	66	61	63	63	62	59	62	64	61	64	68	61	66	63	65	64
Booker Richard	66	64	63	66	67	62		67	64	65	64	67	60	66	64	68	66	76	68	68	67	68	69
Bowie Anthony	68	66	69	69	73	66	67		68	69	64	66	63	69	67	70	67	81	66	72	75	68	74
Brister Antonio	66	63	63	65	67	61	64	68		66	60	61	60	67	65	62	64	70	65	66	66	65	67
Brown Kendall	70	64	66	66	69	63	65	69	66		66	64	65	69	65	67	67	74	68	68	69	66	69
Carter Melvin	66	61	63	63	64	63	64	64	60	66		62	60	62	63	63	66	71	65	65	65	66	66
Carter Rick	66	63	62	64	67	62	67	66	61	64	62		62	63	64	63	67	75	68	68	72	67	71
Clayton Royal	64	60	62	62	64	59	60	63	60	65	60	62		61	63	60	62	67	65	61	65	62	63
Colebrook James	67	64	66	66	69	62	66	69	67	69	62	63	61		66	65	66	73	68	68	68	67	68
Colebrook Sean	67	64	65	65	67	64	64	67	65	65	63	64	63	66		62	67	70	66	67	68	66	67
Crawford Pat	65	61	63	65	65	61	68	70	62	67	63	63	60	65	62		66	75	64	68	67	66	69
Davis Murry	67	64	66	67	68	64	66	67	64	67	66	67	62	66	67	66		74	67	67	68	68	70
Diamond Lorenzo	75	67	71	72	77	68	76	81	70	74	71	75	67	73	70	75	74		75	75	80	76	80
Diaz Mario	67	63	63	66	69	61	68	66	65	68	65	68	65	68	66	64	67	75		67	70	70	70
Dubose Damitoin	72	66	67	68	71	66	68	72	66	68	65	68	61	68	67	68	67	75	67		71	68	70
Edmonds Scott	71	65	67	66	73	63	67	75	66	69	65	72	65	68	68	67	68	80	70	71		67	75
Evans Booker	67	62	63	68	67	65	68	68	65	66	66	67	62	67	66	66	68	76	70	68	67		71
Gardner Mary	68	63	66	68	70	64	69	74	67	69	66	71	63	68	67	69	70	80	70	70	75	71

 

[Eric W]

If the 2 names are in Sheet5!A1:A2 like so:

Book4
	A
1	Archuleta Michael
2	Clayton Royal
Sheet5

Then you can use this CF formula:

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1		Alston James	Anderson Eric	Archuleta Michael	Baker Bea	Bledsoe Darryl	Bolden Anthony	Booker Richard	Bowie Anthony	Brister Antonio	Brown Kendall	Carter Melvin	Carter Rick	Clayton Royal	Colebrook James	Colebrook Sean	Crawford Pat	Davis Murry	Diamond Lorenzo	Diaz Mario	Dubose Damitoin	Edmonds Scott	Evans Booker	Gardner Mary
2	Alston James		64	67	71	71	65	66	68	66	70	66	66	64	67	67	65	67	75	67	72	71	67	68
3	Anderson Eric	64		66	63	65	61	64	66	63	64	61	63	60	64	64	61	64	67	63	66	65	62	63
4	Archuleta Michael	67	66		65	67	63	63	69	63	66	63	62	62	66	65	63	66	71	63	67	67	63	66
5	Baker Bea	71	63	65		69	64	66	69	65	66	63	64	62	66	65	65	67	72	66	68	66	68	68
6	Bledsoe Darryl	71	65	67	69		64	67	73	67	69	64	67	64	69	67	65	68	77	69	71	73	67	70
7	Bolden Anthony	65	61	63	64	64		62	66	61	63	63	62	59	62	64	61	64	68	61	66	63	65	64
8	Booker Richard	66	64	63	66	67	62		67	64	65	64	67	60	66	64	68	66	76	68	68	67	68	69
9	Bowie Anthony	68	66	69	69	73	66	67		68	69	64	66	63	69	67	70	67	81	66	72	75	68	74
10	Brister Antonio	66	63	63	65	67	61	64	68		66	60	61	60	67	65	62	64	70	65	66	66	65	67
11	Brown Kendall	70	64	66	66	69	63	65	69	66		66	64	65	69	65	67	67	74	68	68	69	66	69
12	Carter Melvin	66	61	63	63	64	63	64	64	60	66		62	60	62	63	63	66	71	65	65	65	66	66
13	Carter Rick	66	63	62	64	67	62	67	66	61	64	62		62	63	64	63	67	75	68	68	72	67	71
14	Clayton Royal	64	60	62	62	64	59	60	63	60	65	60	62		61	63	60	62	67	65	61	65	62	63
15	Colebrook James	67	64	66	66	69	62	66	69	67	69	62	63	61		66	65	66	73	68	68	68	67	68
16	Colebrook Sean	67	64	65	65	67	64	64	67	65	65	63	64	63	66		62	67	70	66	67	68	66	67
17	Crawford Pat	65	61	63	65	65	61	68	70	62	67	63	63	60	65	62		66	75	64	68	67	66	69
18	Davis Murry	67	64	66	67	68	64	66	67	64	67	66	67	62	66	67	66		74	67	67	68	68	70
19	Diamond Lorenzo	75	67	71	72	77	68	76	81	70	74	71	75	67	73	70	75	74		75	75	80	76	80
20	Diaz Mario	67	63	63	66	69	61	68	66	65	68	65	68	65	68	66	64	67	75		67	70	70	70
21	Dubose Damitoin	72	66	67	68	71	66	68	72	66	68	65	68	61	68	67	68	67	75	67		71	68	70
22	Edmonds Scott	71	65	67	66	73	63	67	75	66	69	65	72	65	68	68	67	68	80	70	71		67	75
23	Evans Booker	67	62	63	68	67	65	68	68	65	66	66	67	62	67	66	66	68	76	70	68	67		71
24	Gardner Mary	68	63	66	68	70	64	69	74	67	69	66	71	63	68	67	69	70	80	70	70	75	71
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:X24	Expression	=MATCH($A2,Sheet5!$A$1:$A$2,0)<>MATCH(B$1,Sheet5!$A$1:$A$2,0)	text	NO

 

[Rock5150]

If the 2 names are in Sheet5!A1:A2 like so:

Book4
	A
1	Archuleta Michael
2	Clayton Royal
Sheet5

Then you can use this CF formula:

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1		Alston James	Anderson Eric	Archuleta Michael	Baker Bea	Bledsoe Darryl	Bolden Anthony	Booker Richard	Bowie Anthony	Brister Antonio	Brown Kendall	Carter Melvin	Carter Rick	Clayton Royal	Colebrook James	Colebrook Sean	Crawford Pat	Davis Murry	Diamond Lorenzo	Diaz Mario	Dubose Damitoin	Edmonds Scott	Evans Booker	Gardner Mary
2	Alston James		64	67	71	71	65	66	68	66	70	66	66	64	67	67	65	67	75	67	72	71	67	68
3	Anderson Eric	64		66	63	65	61	64	66	63	64	61	63	60	64	64	61	64	67	63	66	65	62	63
4	Archuleta Michael	67	66		65	67	63	63	69	63	66	63	62	62	66	65	63	66	71	63	67	67	63	66
5	Baker Bea	71	63	65		69	64	66	69	65	66	63	64	62	66	65	65	67	72	66	68	66	68	68
6	Bledsoe Darryl	71	65	67	69		64	67	73	67	69	64	67	64	69	67	65	68	77	69	71	73	67	70
7	Bolden Anthony	65	61	63	64	64		62	66	61	63	63	62	59	62	64	61	64	68	61	66	63	65	64
8	Booker Richard	66	64	63	66	67	62		67	64	65	64	67	60	66	64	68	66	76	68	68	67	68	69
9	Bowie Anthony	68	66	69	69	73	66	67		68	69	64	66	63	69	67	70	67	81	66	72	75	68	74
10	Brister Antonio	66	63	63	65	67	61	64	68		66	60	61	60	67	65	62	64	70	65	66	66	65	67
11	Brown Kendall	70	64	66	66	69	63	65	69	66		66	64	65	69	65	67	67	74	68	68	69	66	69
12	Carter Melvin	66	61	63	63	64	63	64	64	60	66		62	60	62	63	63	66	71	65	65	65	66	66
13	Carter Rick	66	63	62	64	67	62	67	66	61	64	62		62	63	64	63	67	75	68	68	72	67	71
14	Clayton Royal	64	60	62	62	64	59	60	63	60	65	60	62		61	63	60	62	67	65	61	65	62	63
15	Colebrook James	67	64	66	66	69	62	66	69	67	69	62	63	61		66	65	66	73	68	68	68	67	68
16	Colebrook Sean	67	64	65	65	67	64	64	67	65	65	63	64	63	66		62	67	70	66	67	68	66	67
17	Crawford Pat	65	61	63	65	65	61	68	70	62	67	63	63	60	65	62		66	75	64	68	67	66	69
18	Davis Murry	67	64	66	67	68	64	66	67	64	67	66	67	62	66	67	66		74	67	67	68	68	70
19	Diamond Lorenzo	75	67	71	72	77	68	76	81	70	74	71	75	67	73	70	75	74		75	75	80	76	80
20	Diaz Mario	67	63	63	66	69	61	68	66	65	68	65	68	65	68	66	64	67	75		67	70	70	70
21	Dubose Damitoin	72	66	67	68	71	66	68	72	66	68	65	68	61	68	67	68	67	75	67		71	68	70
22	Edmonds Scott	71	65	67	66	73	63	67	75	66	69	65	72	65	68	68	67	68	80	70	71		67	75
23	Evans Booker	67	62	63	68	67	65	68	68	65	66	66	67	62	67	66	66	68	76	70	68	67		71
24	Gardner Mary	68	63	66	68	70	64	69	74	67	69	66	71	63	68	67	69	70	80	70	70	75	71
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:X24	Expression	=MATCH($A2,Sheet5!$A$1:$A$2,0)<>MATCH(B$1,Sheet5!$A$1:$A$2,0)	text	NO

Hi eric,

Let say i have different names and pairing where they participated in the low net game. Would i be able to say have 10, 20 or more of names. I was thinking if i did it so partner 1 is column A and partner 2 is column B, then i can have multiple yellow cells on my spreadsheet. so i can have different combos with diff cells highlighted. In the example, i'm fine with it highlighting the two numbers even though its the same people. i won't worry about that.

 

[Eric W]

How about this?

Book4
	A	B
1	Player 1	Player 2
2	Archuleta Michael	Clayton Royal
3	Bledsoe Darryl	Bolden Anthony
4	Colebrook James	Booker Richard
5
6
Sheet5

and

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1		Alston James	Anderson Eric	Archuleta Michael	Baker Bea	Bledsoe Darryl	Bolden Anthony	Booker Richard	Bowie Anthony	Brister Antonio	Brown Kendall	Carter Melvin	Carter Rick	Clayton Royal	Colebrook James	Colebrook Sean	Crawford Pat	Davis Murry	Diamond Lorenzo	Diaz Mario	Dubose Damitoin	Edmonds Scott	Evans Booker	Gardner Mary
2	Alston James		64	67	71	71	65	66	68	66	70	66	66	64	67	67	65	67	75	67	72	71	67	68
3	Anderson Eric	64		66	63	65	61	64	66	63	64	61	63	60	64	64	61	64	67	63	66	65	62	63
4	Archuleta Michael	67	66		65	67	63	63	69	63	66	63	62	62	66	65	63	66	71	63	67	67	63	66
5	Baker Bea	71	63	65		69	64	66	69	65	66	63	64	62	66	65	65	67	72	66	68	66	68	68
6	Bledsoe Darryl	71	65	67	69		64	67	73	67	69	64	67	64	69	67	65	68	77	69	71	73	67	70
7	Bolden Anthony	65	61	63	64	64		62	66	61	63	63	62	59	62	64	61	64	68	61	66	63	65	64
8	Booker Richard	66	64	63	66	67	62		67	64	65	64	67	60	66	64	68	66	76	68	68	67	68	69
9	Bowie Anthony	68	66	69	69	73	66	67		68	69	64	66	63	69	67	70	67	81	66	72	75	68	74
10	Brister Antonio	66	63	63	65	67	61	64	68		66	60	61	60	67	65	62	64	70	65	66	66	65	67
11	Brown Kendall	70	64	66	66	69	63	65	69	66		66	64	65	69	65	67	67	74	68	68	69	66	69
12	Carter Melvin	66	61	63	63	64	63	64	64	60	66		62	60	62	63	63	66	71	65	65	65	66	66
13	Carter Rick	66	63	62	64	67	62	67	66	61	64	62		62	63	64	63	67	75	68	68	72	67	71
14	Clayton Royal	64	60	62	62	64	59	60	63	60	65	60	62		61	63	60	62	67	65	61	65	62	63
15	Colebrook James	67	64	66	66	69	62	66	69	67	69	62	63	61		66	65	66	73	68	68	68	67	68
16	Colebrook Sean	67	64	65	65	67	64	64	67	65	65	63	64	63	66		62	67	70	66	67	68	66	67
17	Crawford Pat	65	61	63	65	65	61	68	70	62	67	63	63	60	65	62		66	75	64	68	67	66	69
18	Davis Murry	67	64	66	67	68	64	66	67	64	67	66	67	62	66	67	66		74	67	67	68	68	70
19	Diamond Lorenzo	75	67	71	72	77	68	76	81	70	74	71	75	67	73	70	75	74		75	75	80	76	80
20	Diaz Mario	67	63	63	66	69	61	68	66	65	68	65	68	65	68	66	64	67	75		67	70	70	70
21	Dubose Damitoin	72	66	67	68	71	66	68	72	66	68	65	68	61	68	67	68	67	75	67		71	68	70
22	Edmonds Scott	71	65	67	66	73	63	67	75	66	69	65	72	65	68	68	67	68	80	70	71		67	75
23	Evans Booker	67	62	63	68	67	65	68	68	65	66	66	67	62	67	66	66	68	76	70	68	67		71
24	Gardner Mary	68	63	66	68	70	64	69	74	67	69	66	71	63	68	67	69	70	80	70	70	75	71
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:X24	Expression	=COUNTIFS(Sheet5!$A$2:$A$50,$A2,Sheet5!$B$2:$B$50,B$1)	text	NO

 

[Rock5150]

It worked! Thank you very much

 

[Eric W]

Happy to help! Thanks for the update. ?