Conditional Formatting using MATCH over 2 Columns

[GallivantingOne]

Date	Start	End	Arena	Home Team	N/S/E/W	Away Team	N/S/E/W	Division
04/03/2023	20:30	21:30	MPS	Kodiaks*	North	Raptors	North	U9Div
04/04/2023	17:30	18:30	CDB	Stony Snipers	West	Screaming Squirrels	North	U11Div1
04/04/2023	19:45	20:45	CMM	The Cedars	North	Bardownski's	North	U11Div1A
04/04/2023	19:30	20:30	CTM	Ice Hawks	North	Spurs	South	U11Div2
04/04/2023	17:30	18:30	CVA	Growlers*	West	The Storm	South	U11Div3
04/04/2023	20:00	21:00	GA	The Cedars B	West	Silverback Heras	West	U11Div4

I am using the above spreadsheet for scheduling hockey teams. I use Conditional Formatting on the Home Team and Away Team columns (E and G) based on the Division. The formula I have been using for these is:
=MATCH($E2:$E900,U18Div1,0) with a range of =$E$2:$E$900 in the "Applies to" field and then another line with the same formatting
=MATCH($G2:$G900,U18Div1,0) with a range of =$G$2:$G$900 in the "Applies to" field
This will change the background color of the teams so they are easier to identify in 900 lines of scheduling and the above formulas work for all the divisions

My questions is whether or not there is a way to combine these to search both columns E and G in one line of conditional formatting. With 18+ divisions it gets a bit cumbersome to deal with. I have tried using AND but I'm not sure it is compatible with the MATCH function. Perhaps I should be using something other than MATCH? Not sure. Any ideas would be welcome.

Thanks

 

[DanteAmor]

Hi @GallivantingOne. Thanks for posting on MrExcel.

Create only a conditional formatting.
Use the following formula:

=MATCH(E2,U18Div1,0)

"Applies to:"

=$E$2:$G$900

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------

 

[GallivantingOne]

That works. I was wondering why I had 2 list the full area instead of the just applies to field. Thanks for the knowledge!