Conditional Formatting

[toomb]

I could do with some conditional formatting help. I'm creating a document for football stats (please see image).

Cell B1: list of all 20 Premier League clubs
Cell B2: select whether I want the home or away colours for the club in B1
Cell D1: list of all 20 Premier League clubs
Cell D2: select whether I want the home or away colours for the club in D1
In these cells, I have 40 conditional formatting rules set up (home and away for all 20 clubs)

Cells B4:C5: has the same conditional formatting as B1 and B2, so if I change anything either the club or home/away, these cells change colour
Cells D4:E5: has the same conditional formatting as D1 and D2, so if I change anything either the club or home/away, these cells change colour

Where I am struggling, is with the cells in I7:I8. I have the formula set up to compare the numbers in columns B and D, and return the name of the team in either B1 or D1. What I want, is for the formatting to then be the same as B1 or D1, but I cannot work out how to do it. I essentially want to be able to do in the image, is set the formatting of I7 to be the same as either B1 or D1, depending on H7.

Any help would be gratefully accepted!
the

 

[jasonb75]

What I want, is for the formatting to then be the same as B1 or D1, but I cannot work out how to do it.

If B1 and D1 are conditionally formatted then apply the same rule to the other ranges that you want to apply the same formats to.
You will probably need to change some (if not all) relative ranges in the formula to absolute ranges.

 

[toomb]

If B1 and D1 are conditionally formatted then apply the same rule to the other ranges that you want to apply the same formats to.
You will probably need to change some (if not all) relative ranges in the formula to absolute ranges.

I had tried this, but B1 and D1 will always have different formatting to each other (because the same team can't play itself!), and I want I7 to have the same formatting as either B1 or D1, dependent on the result in H7 (I hope that makes sense)

 

[jasonb75]

I hope that makes sense

Yes and no, I understand what you mean but there is not enough information in the screen captures for it to make complete sense.

Please use XL2BB to post your sample (link below) so that the conditional formatting formulas and associated formats are clearly visible with the data.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

Also, please update your account profile to show your primary version of excel (click your user name at the top right of the page, then go to 'Account Details' scroll down and check the relevant box, then scroll to the bottom and save).

 

[toomb]

Apologies. I have added my primary version to my profile (Excel for Office 365).

My data is below (thank you very much for the help!)

2019-20 Club Data.xlsx
	A	B	C	D	E	F	G	H	I
1	Select Club:	Everton		Aston Villa
2	Colour Scheme	Home		Home
3
4	Filter: Full Season	Home Team: Everton		Away Team: Aston Villa		Difference	Reverse Sort	Better Team	Better Team
5	Attack and Defence	Actual	Ranking	Actual	Ranking
6	Attack
7	Shots For per Match	12.66	7	12.09	10	-0.57		Home	Everton
8	Shots on Target For per Match	4.40	8	4.06	11	-0.34		Home	Everton
9	xG For per Match	1.41	8	1.16	17	-0.25		Home	Everton
10	Goals For per Match	1.17	11	1.09	13	-0.09		Home	Everton
11	Shots per Goal Scored	10.80	15	11.13	16	0.33	Y	Home	Everton
12	xG For per Shot	0.11	12	0.10	17	-0.02		Home	Everton
H2H

Cell Formulas
Range	Formula
B4	B4	="Home Team: "&$B$1
D4	D4	="Away Team: "&$D$1
B7:B12	B7	=VLOOKUP($A7,Ranking!$A:$C,2,FALSE)
C7:C12	C7	=VLOOKUP($A7,Ranking!$A:$C,3,FALSE)
D7:D12	D7	=VLOOKUP($A7,Ranking!$K:$S,2,FALSE)
E7:E12	E7	=VLOOKUP($A7,Ranking!$K:$S,3,FALSE)
F7:F12	F7	=D7-B7
H7:H12	H7	=IF(G7="Y",IF(D7<B7,"Away",IF(D7=B7,"-","Home")),IF(D7>B7,"Away",IF(D7<B7,"Home","-")))
I7:I12	I7	=IF(G7="Y",IF(D7<B7,$D$1,IF(D7=B7,"-",$B$1)),IF(D7>B7,$D$1,IF(D7<B7,$B$1,"-")))

Named Ranges
Name	Refers To	Cells
Ranking!_FilterDatabase	=Ranking!$A$3:$C$58	B7:C12

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Away",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Home",$D$2))	text	NO
D1	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Home",$D$2))	text	NO
B1	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Away",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Home",$B$2))	text	NO
B1	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Away",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Home",$B$2))	text	NO
I7	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Home",$B$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Away",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Home",$D$2))	text	NO
D5:E5,D4	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Home",$D$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Away",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Home",$B$2))	text	NO
B5:C5,B4	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Home",$B$2))	text	NO
D2	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Away",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Wolves",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("West Ham",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Watford",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Tottenham",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Southampton",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Sheffield United",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Norwich",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Newcastle",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Man United",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Man City",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Liverpool",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Leicester",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Everton",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Crystal Palace",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Chelsea",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Burnley",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Brighton",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Aston Villa",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Arsenal",$D$1),SEARCH("Home",$D$2))	text	NO
D2	Expression	=AND(SEARCH("Bournemouth",$D$1),SEARCH("Home",$D$2))	text	NO
B2	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Away",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Wolves",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("West Ham",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Watford",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Tottenham",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Southampton",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Sheffield United",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Norwich",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Newcastle",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Man United",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Man City",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Liverpool",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Leicester",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Everton",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Crystal Palace",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Chelsea",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Burnley",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Brighton",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Aston Villa",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Arsenal",$B$1),SEARCH("Home",$B$2))	text	NO
B2	Expression	=AND(SEARCH("Bournemouth",$B$1),SEARCH("Home",$B$2))	text	NO
F1	Expression	=AND(SEARCH("Norwich",$D$1),(SEARCH("Away",$D$2)))	text	NO
I40:I46,S40:S46,I8:I12,I15:I19,S15:S19,AC15:AC19	Cell Value	contains ""	text	NO
I8:I12	Cell Value	contains "Wolves"	text	NO
I8:I12	Cell Value	contains "Wolves"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Wolves"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Liverpool"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Burnley"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "West Ham"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Watford"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Tottenham"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Southampton"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Sheffield United"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Norwich"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Newcastle"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Man United"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Man City"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Everton"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Leicester"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Crystal Palace"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Chelsea"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Brighton"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Bournemouth"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Aston Villa"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Arsenal"	text	NO
I27,I22:I25,I30:I35,I40:I46,S40:S46,I8:I19,S14:S19,AC14:AC19	Cell Value	contains "Everton"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B1,D1	List	='All Clubs'!$A$5:$A$24
B2,D2	List	=Ranking!$AE$1:$AE$2