Formula to count partial colored font using wildcards

[jMz]

Good morning,

I am having a problem counting colored font while using a wildcard for a partial search in a cell. The font color I want to count is "Green" which only appears once in each column to show a winner's name a long with the winning number. Ex: "5. Stephen". The number and name have to stay together, which is where my problem falls, a player can pick multiple numbers in one column but there can only be one winning number and name.
When I type a name "Stephen" in column E3 the formula should count Stephen one time in each column that the name appears as green and over looking the number at the beginning.

I have attached an example. Any ideas would be appreciated, thank you.

Jim

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		NUMBER OF								*** Total Spins ***	1	2	3	4	5
2		Spins	Wins	Picks	Player					5	1. Austin Rowe	1. Chris Leiter	1. Stephen Gross	1. Stephen Gross	1. Stephen Gross
3		4	#NAME?	15	Stephen Gross						2. Rick Conte	2. Daniel Branco	2. Daniel Branco	2. Daniel Branco	2. Stephen Gross
4			Function Called								3. Rick Conte	3. Aaron Burris	3. Calvin VanRiper	3. Stephen Gross	3. Stephen Gross
5											4. Shane Fair	4. Shane Fair	4. Shane Fair	4. Shane Fair	4. John Alger
6											5. Stephen Gross	5. Chris Leiter	5. Calvin VanRiper	5. Stephen Gross	5. Stephen Gross
7											6. Shane Fair	6. Shane Fair	6. Shane Fair	6. Shane Fair	6. Shane Fair
8											7. Tim and Kim Taylor	7. Daniel Branco	7. Calvin VanRiper	7. Stephen Gross	7. Stephen Gross
9											8. Randy Czapla	8. Daniel Branco	8. Daniel Branco	8. Daniel Branco	8. John Alger
10											9. Shane Fair	9. Shane Fair	9. Shane Fair	9. Shane Fair	9. Shane Fair
11											10. Stephen Gross	10. Sandie Smith	10. Sandie Smith	10. Sandie Smith	10. Calvin VanRiper
12											11. Lee Clyde	11. Tim and Kim Taylor	11. Stephen Gross	11. Austin Rowe	11. Calvin VanRiper
13											12. Sandie Smith	12. Daniel Branco	12. Daniel Branco	12. Daniel Branco	12. Shane Fair
14											13. Calvin VanRiper	13. Lee Clyde	13. John Alger	13. Tim and	13. Laura N
15											14. Rick Conte	14. Aaron Burris	14. Stephen Gross	14. Calvin VanRiper	14. Laura N
16											15. Calvin VanRiper	15. Jason Easter	15. Stephen Gross	15. Calvin VanRiper	15. Laura N
17										Winning Number	5	11	2	15	2
18
19
Feb-18

Cell Formulas
Range	Formula
J2	J2	=COUNT(K1:O1)
C3	C3	=CountCellsByFontColor(K1:O15,"*"&E3&"*")
D3	D3	=COUNTIF(K2:O16, "*"&E3&"*")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G6:G8	Cell Value	="No"	text	NO
G6:G14,G16:G50	Cell Value	="Yes"	text	NO
G4	Cell Value	="No"	text	NO
G4	Cell Value	="Yes"	text	NO

 

[jMz]

Is there a easy way to count the number of columns with a green name?

jim

 

[MARK858]

Is there a easy way to count the number of columns with a green name?

Before we start writing/rewriting code due to new requests, can you have a think if you have any other requirements to add rather than us writing it piecemeal

 

[jMz]

Before we start writing/rewriting code due to new requests, can you have a think if you have any other requirements to add rather than us writing it piecemeal

Sure, wasn't thinking.