Just asking for condition format suggestions for rules

[SportzQnoA]

I have a question for a conditional format specifically this:

NFL Scouts 2022.xlsx
	A
1	Conditions List:
2	Add anyone that has a title with "scouting" or "personnel" in it.
3	I don't need people with "administration" in their title or any cap guys, despite having one listed from the Niners
4	Make sure every scout keeps the same number
5	If a scout is added to one team from another team, make sure his number travels with him.
6	Don't create numbers for scouts you add; just make them this color
7	If a scout's name is already there, but he has a new title, update the title and highlight him in this color
8	If you bring in a scout from another team, make him this color
9	If there are NO changes for a scout who's already listed, he'll stay this color
10	Remember: Do NOT add numbers to any of the scouts. Just make sure to keep the ones that do have them.
11	No need to add scouting assistants
Sheet4

NFL Scouts 2022.xlsx
	A	B	C	D	E	F
2	2	49ers	Lynch, John	John	Lynch	GM
3	3	49ers	Peters, Adam	Adam	Peters	Assistant GM
4	4	49ers	Waugh, Ethan	Ethan	Waugh	Vice President, Player Personnel
5	5	49ers	Carthon, Ran	Ran	Carthon	Director of Player Personnel
6	6	49ers	Gillen, R.J.	R.J.	Gillen	Director of Pro Personnel
7	7	49ers	Ahmad, Tariq	Tariq	Ahmad	Director of College Scouting
8	8	49ers	Flanagan, Chip	Chip	Flanagan	National Scout
9	9	49ers	Chabot, Justin	Justin	Chabot	Assistnat Director, College Scouting
10	10	49ers	Clavelle, Salli	Salli	Clavelle	Area Scout
11	11	49ers	DeCicco, Dom	Dom	DeCicco	Area Scout
12	12	49ers	Williams, Joshua	Joshua	Williams	Area Scout
13	13	49ers	Kessenich, Ryan	Ryan	Kessenich	Area Scout
14	14	49ers	Rubio, Steve	Steve	Rubio	Area Scout
15		49ers	Thatcher, Eric	Eric	Thatcher	Area Scout
16		49ers	Gammage, Fred III	Fred III	Gammage	Pro Scout
17	15	49ers	Slowik, Steve	Steve	Slowik	Pro Scout
18		49ers	Hanlon, Crowley	Crowley	Hanlon	Pro Scout
19		49ers	Frey, Hayden	Hayden	Frey	College Scout
20		49ers	Seumalo, Jessi	Jessi	Seumalo	Coordinator, Player Personnel
21	16	49ers	Buffum, Richard	Richard	Buffum	Manager, Football Administration
22	17	Bears	Poles, Ryan	Ryan	Poles	GM
23	18	Bears	Cunningham, Ian	Ian	Cunningham	Assistant GM
24	19	Bears	Sadowski, Mark	Mark	Sadowski	Director of College Scouting
25	20	Bears	Koziol, Trey	Trey	Koziol	Co-Director of Player Personnel
26	21	Bears	Prescott, Chris	Chris	Prescott	National Scout
27	22	Bears	Saint-Paul, Francis	Francis	Saint-Paul	National Scout
28	23	Bears	Summerville, Sam	Sam	Summerville	National Scout
29	24	Bears	Shiver, Jeff	Jeff	Shiver	Executive Scout
30	25	Bears	Ackley, Breck	Breck	Ackley	Area Scout
31	26	Bears	Hamel, Scott	Scott	Hamel	Area Scout
32	27	Bears	Rehor, Brendan	Brendan	Rehor	Area Scout
33	28	Bears	Syty, John	John	Syty	Area Scout
34	29	Bears	Williams, David	David	Williams	Area Scout
35	30	Bears	Raucina Drew	Drew	Raucina	Combine Scout
36	31	Bears	Macedo, Bobby	Bobby	Macedo	Scouting Coordinator
37	32	Bears	Love, Charles	Charles	Love	Scouting Assistant
38	33	Bears	Washington, Ashton	Ashton	Washington	Scouting Assistant
39	34	Bears	King, Jeff	Jeff	King	Director of Pro Scouting
40	35	Bears	White, Chris	Chris	White	Pro Scout
41	36	Bengals	Brown, Paul	Paul	Brown	Vice President of Player Personnel
42	37	Bengals	Tobin, Duke	Duke	Tobin	Director of Player Personnel
43	38	Bengals	Potts, Mike	Mike	Potts	Scouting Director (College)
44	39	Bengals	Radicevic, Steven	Steven	Radicevic	Scouting Director (Pro)
45	40	Bengals	Tobin, Bill	Bill	Tobin	Personnel Executive
46	41	Bengals	Brown, Trey	Trey	Brown	Scout
47	42	Bengals	Johnson, Andrew	Andrew	Johnson	Scout
48	43	Bengals	Sarkisian, Christian	Christian	Sarkisian	Scout
49	44	Bills	Boyd, Malik	Malik	Boyd	Senior Director of Pro Scouting
50	45	Bills	Gray, Terrance	Terrance	Gray	Assistant Director of Player Personnel
51	46	Bills	Dawson, Lake	Lake	Dawson	Asst. Dir of College Scouting
52	47	Bills	Marrow, Chris	Chris	Marrow	Asst Director of Pro Scouting/Team Advances
53	48	Bills	Rukavina, Curtis	Curtis	Rukavina	Asst. Director of Pro Scouting/Free Agency
54	49	Bills	Fisher, Brian	Brian	Fisher	Area Scout
55	50	Bills	Gaine, Brian	Brian	Gaine	Senior Personnel Advisor
56	51	Bills	Gosper, Andrea	Andrea	Gosper	Player Personnel Coordinator
57	52	Bills	Harris, Pete	Pete	Harris	Area Scout
58	53	Bills	Hickey, Dennis	Dennis	Hickey	Senior National Scout
59	54	Bills	Highsmith, A.J.	Aj	Highsmith	Area Scout
60	55	Bills	Jennings, Keith	Keith	Jennings	BLESTO Scout
61	56	Bills	Majeski, Doug	Doug	Majeski	Senior College Scout
62	57	Bills	Pratt, Tyler	Tyler	Pratt	Area Scout
63	58	Bills	Mulbah, Asil	Asil	Mulbah	Pro Scout
64	59	Bills	Szabo, Mike	Mike	Szabo	Area Scout
65	60	Bills	Webb, R.J.	R.J.	Webb	Pro Scout
66	61	Bills	Meganck, Kevin	Kevin	Meganck	VP of Football Administration
67	62	Bills	Overdorf, Jim	Jim	Overdorf	Senior Advisor to GM/Football Operations
68	63	Broncos	Paton, George	George	Paton	GM
69	64	Broncos	Kleine, Kelly	Kelly	Kleine	Executive Director of Football Operations/Special Advisor to the GM
70	65	Broncos	Mougey, Darren	Darren	Mougey	Assistant GM
71	66	Broncos	Durso, A.J.	A.J.	Durso	Director of Pro Personnel
72	67	Broncos	Stark, Brian	Brian	Stark	Director of College Scouting
73	68	Broncos	Phifer, Roman	Roman	Phifer	Senior Personnel Executive
74	69	Broncos	Dizon, Jordon	Jordon	Dizon	Assistant Director of Pro Scouting
75	70	Broncos	Schiralli, Nick	Nick	Schiralli	Assistant Director of College Scouting
76	71	Broncos	Jo, Sae Woon	Sae Woon	Jo	Western National Scout
77	72	Broncos	Armstrong, Eugene	Eugene	Armstrong	Southwest Area Scout
78	73	Broncos	Bratten, Dave	Dave	Bratten	College Scouting Coordinator/West Area Scout
79	74	Broncos	Chesin, Bryan	Bryan	Chesin	Midwest Area Scout
80	75	Broncos	Distefano, Scott	Scott	Distefano	Senior College Consultant (Midwest)
81	76	Broncos	Paton, Rob	Rob	Paton	Scouting Coordinator
82	77	Broncos	Randall, Deon	Deon	Randall	Northeast Area Scout
83	78	Broncos	Walsh, Patrick	Patrick	Walsh	Pro Scout
84	79	Broncos	Burton, Roya	Roya	Burton	Player Personnel Assistant
85	80	Broncos	Hurtado, Richard	Richard	Hurtado	VP of Football Administration
original

NFL Scouts 2022.xlsx
	I	J	K	L	M
2	Chabot, Justin	49ers	National Scout	49ers	Assistant Director of College Scouting
3	Frey, Hayden	49ers	Scouting Assistant	49ers	College Scout
4	Gatson, Tyren	Auburn	Associate DPP/Recruiting Operations	49ers	Scouting Assistant
5	Hannon, Crowley	49ers	Pro Personnel Coordinator	49ers	Pro Scout
6	Seumalo, Jessi	49ers	Scouting Assistant	49ers	Coordinator, Player Personnel
7	Slowik, Steve	49ers	Area Scout	49ers	Pro Scout
8	Thatcher, Eric	U. Albany	Safeties coach	49ers	Area Scout
9	Ackley, Breck	Bears	Area Scout	Bears	Assistant Director of College Scouting
10	Bradway, Tom	Raiders	Combine Scout	Bears	Area Scout (Northeast)
11	Cavanaugh, Ryan	Ohio State	College Scouting Coordinator	Bears	Area Scout
12	Cosh, James	Bears	Salary Cap/Pro Scouting Analyst	Bears	Manager of Football Administration/Pro Scout
13	Cunningham, Ian	Eagles	Director of Player Personnel	Bears	Assistant GM
14	Hicks, Reese	Falcons	Pro Scout	Bears	Area Scout (West Coast)
15	Love, Charles	Bears	Scouting Assistant	Bears	Pro Scout
16	Poles, Ryan	Chiefs	Executive Director of Player Personnel	Bears	GM
17	Rehor, Brendan	Bears	Area Scout (Midwest)	Bears	Area Scout (Southeast)
18	Santarelli, Mike	Bears	Director of Football Systems	Bears	Executive Director of Football Technology
19	St. Paul, Francis	Bears	National Scout	Bears	Senior National Scout
20	Summerville, Sam	Bears	National Scout	Bears	Senior National Scout
21	Syty, John	Bears	Area Scout (Northeast)	Bears	Area Scout (Southwest)
22	Washington, Ashton	Bears	Scouting Assistant	Bears	Player Personnel Coordinator
23	Weese, Ryan	Montana State	General Manager	Bears	Scouting Assistant
24	White, Chris	Bears	Pro Scout	Bears	Assistant Director of Pro Scouting
25	Brown, Trey	Bengals	Scout	Bengals	Senior Personnel Executive
26	Bazirgan, Matt	Texans	Assistant Director of Player Personnel	Bills	Senior Personnel Executive
27	Dotson, Alonzo	Jets	Area Scout (Southeast)	Bills	National Scout
28	Gaine, Brian	Bills	Senior Personnel Advisor	Bills	Assistant GM
29	Gray, Terrance	Bills	Assistant Director of Player Personnel	Bills	Director of Player Personnel
30	Pratt, Tyler	Bills	Area Scout (West Coast)	Bills	Area Scout (Southeast)
31	Szabo, Mike	Bills	Area Scout	Bills	College National Scout
32	Armstrong, Eugene	Broncos	Area Scout (Southwest)	Broncos	Area Scout (Southeast)
33	Bratten, Dave	Broncos	College Scouting Coordinator/Area Scout (Midwest)	Broncos	Area Scout (West Coast)
34	Burckhardt, Reed	Vikings	Assistant Director of Pro Scouting	Broncos	Director of Player Personnel
35	Chesin, Bryan	Broncos	Area Scout	Broncos	Midwest National Scout
36	DiStefano, Scott	Broncos	Senior College Consultant	Broncos	Senior Midwest Area Scout
37	McKenzie, Chaz	Broncos	Nunn-Wooten Scouting Fellow	Broncos	Area Scout (Northeast)
38	Paton, Rob	Broncos	Scouting Coordinator	Broncos	Regional Scout
39	Randall, Deon	Broncos	Area Scout (Northeast)	Broncos	Area Scout (Southwest)
Sheet4