Just asking for condition format suggestions for rules

SportzQnoA

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


NFL Scouts 2022.xlsx
ABCDEF
2249ersLynch, JohnJohnLynchGM
3349ersPeters, AdamAdamPetersAssistant GM
4449ersWaugh, EthanEthanWaughVice President, Player Personnel
5549ersCarthon, RanRan CarthonDirector of Player Personnel
6649ersGillen, R.J.R.J.GillenDirector of Pro Personnel
7749ersAhmad, TariqTariqAhmadDirector of College Scouting
8849ersFlanagan, ChipChipFlanaganNational Scout
9949ersChabot, JustinJustinChabotAssistnat Director, College Scouting
101049ersClavelle, SalliSalliClavelleArea Scout
111149ersDeCicco, DomDomDeCiccoArea Scout
121249ersWilliams, JoshuaJoshuaWilliamsArea Scout
131349ersKessenich, RyanRyanKessenichArea Scout
141449ersRubio, SteveSteveRubioArea Scout
1549ersThatcher, EricEricThatcherArea Scout
1649ersGammage, Fred IIIFred IIIGammagePro Scout
171549ersSlowik, SteveSteveSlowikPro Scout
1849ersHanlon, CrowleyCrowleyHanlonPro Scout
1949ersFrey, HaydenHaydenFreyCollege Scout
2049ersSeumalo, JessiJessi SeumaloCoordinator, Player Personnel
211649ersBuffum, RichardRichardBuffumManager, Football Administration
2217BearsPoles, RyanRyanPolesGM
2318BearsCunningham, IanIanCunninghamAssistant GM
2419BearsSadowski, MarkMarkSadowskiDirector of College Scouting
2520BearsKoziol, TreyTreyKoziolCo-Director of Player Personnel
2621BearsPrescott, ChrisChrisPrescottNational Scout
2722BearsSaint-Paul, FrancisFrancisSaint-PaulNational Scout
2823BearsSummerville, SamSamSummervilleNational Scout
2924BearsShiver, JeffJeffShiverExecutive Scout
3025BearsAckley, BreckBreckAckleyArea Scout
3126BearsHamel, ScottScottHamelArea Scout
3227BearsRehor, BrendanBrendanRehorArea Scout
3328BearsSyty, JohnJohnSytyArea Scout
3429BearsWilliams, DavidDavidWilliamsArea Scout
3530BearsRaucina DrewDrewRaucinaCombine Scout
3631BearsMacedo, BobbyBobbyMacedoScouting Coordinator
3732BearsLove, CharlesCharlesLoveScouting Assistant
3833BearsWashington, AshtonAshtonWashingtonScouting Assistant
3934BearsKing, JeffJeffKingDirector of Pro Scouting
4035BearsWhite, ChrisChrisWhitePro Scout
4136BengalsBrown, PaulPaulBrownVice President of Player Personnel
4237BengalsTobin, DukeDukeTobinDirector of Player Personnel
4338BengalsPotts, MikeMikePottsScouting Director (College)
4439BengalsRadicevic, StevenStevenRadicevicScouting Director (Pro)
4540BengalsTobin, BillBillTobinPersonnel Executive
4641BengalsBrown, TreyTreyBrownScout
4742BengalsJohnson, AndrewAndrewJohnsonScout
4843BengalsSarkisian, ChristianChristianSarkisianScout
4944BillsBoyd, MalikMalikBoydSenior Director of Pro Scouting
5045BillsGray, TerranceTerranceGrayAssistant Director of Player Personnel
5146BillsDawson, LakeLakeDawsonAsst. Dir of College Scouting
5247BillsMarrow, ChrisChrisMarrowAsst Director of Pro Scouting/Team Advances
5348BillsRukavina, CurtisCurtisRukavinaAsst. Director of Pro Scouting/Free Agency
5449BillsFisher, BrianBrianFisherArea Scout
5550BillsGaine, BrianBrianGaineSenior Personnel Advisor
5651BillsGosper, AndreaAndreaGosperPlayer Personnel Coordinator
5752BillsHarris, PetePeteHarrisArea Scout
5853BillsHickey, DennisDennisHickeySenior National Scout
5954BillsHighsmith, A.J.AjHighsmithArea Scout
6055BillsJennings, KeithKeithJenningsBLESTO Scout
6156BillsMajeski, DougDougMajeskiSenior College Scout
6257BillsPratt, TylerTylerPrattArea Scout
6358BillsMulbah, AsilAsilMulbahPro Scout
6459BillsSzabo, MikeMikeSzaboArea Scout
6560BillsWebb, R.J.R.J.WebbPro Scout
6661BillsMeganck, KevinKevinMeganckVP of Football Administration
6762BillsOverdorf, JimJimOverdorfSenior Advisor to GM/Football Operations
6863BroncosPaton, GeorgeGeorgePatonGM
6964BroncosKleine, KellyKellyKleineExecutive Director of Football Operations/Special Advisor to the GM
7065BroncosMougey, DarrenDarrenMougeyAssistant GM
7166BroncosDurso, A.J.A.J.DursoDirector of Pro Personnel
7267BroncosStark, BrianBrianStarkDirector of College Scouting
7368BroncosPhifer, RomanRomanPhiferSenior Personnel Executive
7469BroncosDizon, JordonJordonDizonAssistant Director of Pro Scouting
7570BroncosSchiralli, NickNickSchiralliAssistant Director of College Scouting
7671BroncosJo, Sae WoonSae WoonJoWestern National Scout
7772BroncosArmstrong, EugeneEugeneArmstrongSouthwest Area Scout
7873BroncosBratten, DaveDaveBrattenCollege Scouting Coordinator/West Area Scout
7974BroncosChesin, BryanBryanChesinMidwest Area Scout
8075BroncosDistefano, ScottScottDistefanoSenior College Consultant (Midwest)
8176BroncosPaton, RobRobPatonScouting Coordinator
8277BroncosRandall, DeonDeonRandallNortheast Area Scout
8378BroncosWalsh, PatrickPatrickWalshPro Scout
8479BroncosBurton, RoyaRoyaBurtonPlayer Personnel Assistant
8580BroncosHurtado, RichardRichardHurtadoVP of Football Administration
original



NFL Scouts 2022.xlsx
IJKLM
2Chabot, Justin49ersNational Scout49ersAssistant Director of College Scouting
3Frey, Hayden49ersScouting Assistant49ersCollege Scout
4Gatson, TyrenAuburnAssociate DPP/Recruiting Operations49ersScouting Assistant
5Hannon, Crowley49ersPro Personnel Coordinator49ersPro Scout
6Seumalo, Jessi49ersScouting Assistant49ersCoordinator, Player Personnel
7Slowik, Steve49ersArea Scout49ersPro Scout
8Thatcher, EricU. AlbanySafeties coach49ersArea Scout
9Ackley, BreckBearsArea ScoutBearsAssistant Director of College Scouting
10Bradway, TomRaidersCombine ScoutBearsArea Scout (Northeast)
11Cavanaugh, RyanOhio StateCollege Scouting CoordinatorBearsArea Scout
12Cosh, JamesBearsSalary Cap/Pro Scouting AnalystBearsManager of Football Administration/Pro Scout
13Cunningham, IanEaglesDirector of Player PersonnelBearsAssistant GM
14Hicks, ReeseFalconsPro ScoutBearsArea Scout (West Coast)
15Love, CharlesBearsScouting AssistantBearsPro Scout
16Poles, RyanChiefsExecutive Director of Player PersonnelBearsGM
17Rehor, BrendanBearsArea Scout (Midwest)BearsArea Scout (Southeast)
18Santarelli, MikeBearsDirector of Football SystemsBearsExecutive Director of Football Technology
19St. Paul, FrancisBearsNational ScoutBearsSenior National Scout
20Summerville, SamBearsNational ScoutBearsSenior National Scout
21Syty, JohnBearsArea Scout (Northeast)BearsArea Scout (Southwest)
22Washington, AshtonBearsScouting AssistantBearsPlayer Personnel Coordinator
23Weese, RyanMontana StateGeneral ManagerBearsScouting Assistant
24White, ChrisBearsPro ScoutBearsAssistant Director of Pro Scouting
25Brown, TreyBengalsScoutBengalsSenior Personnel Executive
26Bazirgan, MattTexansAssistant Director of Player PersonnelBillsSenior Personnel Executive
27Dotson, AlonzoJetsArea Scout (Southeast)BillsNational Scout
28Gaine, BrianBillsSenior Personnel AdvisorBillsAssistant GM
29Gray, TerranceBillsAssistant Director of Player PersonnelBillsDirector of Player Personnel
30Pratt, TylerBillsArea Scout (West Coast)BillsArea Scout (Southeast)
31Szabo, MikeBillsArea ScoutBillsCollege National Scout
32Armstrong, EugeneBroncosArea Scout (Southwest)BroncosArea Scout (Southeast)
33Bratten, DaveBroncosCollege Scouting Coordinator/Area Scout (Midwest)BroncosArea Scout (West Coast)
34Burckhardt, ReedVikingsAssistant Director of Pro ScoutingBroncosDirector of Player Personnel
35Chesin, BryanBroncosArea ScoutBroncosMidwest National Scout
36DiStefano, ScottBroncosSenior College ConsultantBroncosSenior Midwest Area Scout
37McKenzie, ChazBroncosNunn-Wooten Scouting FellowBroncosArea Scout (Northeast)
38Paton, RobBroncosScouting CoordinatorBroncosRegional Scout
39Randall, DeonBroncosArea Scout (Northeast)BroncosArea Scout (Southwest)
Sheet4
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top