Conditional Formatting with Criteria

[gtd526]

Hello,
I want to add Conditional Formatting, Highlight AH:AM if greater than the cell above or below. These are NFL teams facing each other (2 lines per game, 4,5--6,7--8,9--10,11 thru Row 35.

A:A and AW:AW have to match, then highlight AH:AM if ALL are greater than the other.
It should work for BUF, DAL(even if there's a Tie), DET, PHI, BAL, MIA, SEA, KC

Right know its highlighting yellow if its greater than the other.

Thank you.

NFL.xlsm
	A																																	AH	AI	AJ	AK	AL	AM										AW
1	Week:																																		Points
2	Teams																																	NY/A	Pts/D	Pts/G	Sc %	3D Conversion	ANY/A										My Fav
3																																		15	16	17	18	19	20
4	LVR																																	5.9	2.3	24	50	40%	5.5										LVR
5	LAR																																	5.4	1.79	18	35.9	44%	4.3
6	NYJ																																	5.5	1.67	19	32.6	37%	5.0
7	BUF																																	6.7	2.63	28	47.5	56%	7.0										BUF
8	CLE																																	6	2.46	26	46.3	45%	5.9
9	CIN																																	5.9	1.88	23	37.5	47%	5.8										CIN
10	HOU																																	5.4	1.52	18	31.3	27%	4.9
11	DAL																																	6.1	1.6	18	35.6	30%	6.4										DAL
12	MIN																																	6	1.98	22	38.6	31%	5.6
13	DET																																	6.9	2.88	35	45.8	38%	7.5										DET
14	PHI																																	8.2	2.44	29	40	43%	8.1										PHI
15	NYG																																	4.6	1.69	19	35.6	32%	4.0
16	BAL																																	7	2.51	30	42.2	40%	7.3										BAL
17	PIT																																	5.3	1.43	18	30.4	37%	3.9
18	JAX																																	6.5	2.23	26	40.9	39%	7.0										JAX
19	TEN																																	6.6	1.79	19	31	38%	6.3
20	MIA																																	7.9	2.42	24	42.1	42%	7.9										MIA
21	LAC																																	7.2	2.09	23	36.4	41%	7.8
22	TB																																	6.2	1.65	20	34.8	35%	6.7										TB
23	SF																																	6.6	1.45	18	27.3	37%	6.3
24	CAR																																	5.2	1.47	20	31.1	26%	4.8
25	SEA																																	7.1	2.38	24	44.1	55%	7.0										SEA
26	KC																																	7	2.93	32	50	51%	7.9										KC
27	DEN																																	6.3	1.5	16	31.8	35%	6.6
28	NE																																	6.7	1.62	18	28.6	39%	5.4										NE
29	ARZ																																	5.2	1.98	22	36.6	31%	5.2
30
31
32
33
34
35
Sheet1

Cell Formulas
Range	Formula
AH4:AH35	AH4	=IFERROR(VLOOKUP($A4,Stats!$Q$3:$AL$34,22,0),"")
AI4:AI35	AI4	=IFERROR(VLOOKUP($A4,Stats!$BZ$3:$CL$44,13,0),"")
AJ4:AJ35	AJ4	=IFERROR(VLOOKUP($A4,Stats!$AR$3:$BN$34,22,0),"")
AK4:AK35	AK4	=IFERROR(VLOOKUP($A4,Stats!$BZ$3:$CF$100,7,0),"")
AL4:AL35	AL4	=IFERROR(VLOOKUP($A4,Stats!$EE$3:$EK$44,7,0),"")
AM4:AM35	AM4	=IFERROR(VLOOKUP($A4,Stats!$Q$3:$AM$34,23,0),"")
AW4,AW34,AW32,AW30,AW28,AW26,AW24,AW22,AW20,AW18,AW16,AW14,AW12,AW10,AW8,AW6	AW4	=IFERROR(IFS($AV4>$AV5,$A4,$A4<>"",IF($AV4=$AV5,"Tie","")),"")
AW5,AW35,AW33,AW31,AW29,AW27,AW25,AW23,AW21,AW19,AW17,AW15,AW13,AW11,AW9,AW7	AW5	=IFERROR(IFS($AV5>$AV4,$A5,$A5<>"",IF($AV4=$AV5,"Tie","")),"")

 

[gtd526]

Everything is working well. Thank you for the formulas.

Hello, this is using Conditional Formatting to highlight cells if TRUE, and its working.
How can I add to the formula if $A4 (team) is showing in another cell range (G52:G66) then return FALSE so it doesn't show highlights.
Thank you.

 

[HongRu]

Hello, this is using Conditional Formatting to highlight cells if TRUE, and its working.
How can I add to the formula if $A4 (team) is showing in another cell range (G52:G66) then return FALSE so it doesn't show highlights.
Thank you.

Try this.

Select AH4:AM29。
Add conditional formatting as the first Criteria
=COUNTIF($G$52:$G$66,$A4)>0
check "Stop If True" as True.

NFL score highlight-1.xlsx
	A																																	AH	AI	AJ	AK	AL	AM										AW
1	Week:																																		Points
2	Teams																																	NY/A	Pts/D	Pts/G	Sc %	3D Conversion	ANY/A										My Fav
3																																		15	16	17	18	19	20
4	LVR																																	5.9	2.3	24	50	40%	5.5										LVR
5	LAR																																	5.4	1.79	18	35.9	44%	4.3
6	NYJ																																	5.5	1.67	19	32.6	37%	5
7	BUF																																	6.7	2.63	28	47.5	56%	7										BUF
8	CLE																																	6	2.46	26	46.3	45%	5.9
9	CIN																																	5.9	1.88	23	37.5	47%	5.8										CIN
10	HOU																																	5.4	1.52	18	31.3	27%	4.9
11	DAL																																	6.1	1.6	18	35.6	30%	6.4										DAL
12	MIN																																	6	1.98	22	38.6	31%	5.6
13	DET																																	6.9	2.88	35	45.8	38%	7.5										DET
14	PHI																																	8.2	2.44	29	40	43%	8.1										PHI
15	NYG																																	4.6	1.69	19	35.6	32%	4
16	BAL																																	7	2.51	30	42.2	40%	7.3										BAL
17	PIT																																	5.3	1.43	18	30.4	37%	3.9
18	JAX																																	6.5	2.23	26	40.9	39%	7										JAX
19	TEN																																	6.6	1.79	19	31	38%	6.3
20	MIA																																	7.9	2.42	24	42.1	42%	7.9										MIA
21	LAC																																	7.2	2.09	23	36.4	41%	7.8
22	TB																																	6.2	1.65	20	34.8	35%	6.7										TB
23	SF																																	6.6	1.45	18	27.3	37%	6.3
24	CAR																																	5.2	1.47	20	31.1	26%	4.8
25	SEA																																	7.1	2.38	24	44.1	55%	7										SEA
26	KC																																	7	2.93	32	50	51%	7.9										KC
27	DEN																																	6.3	1.5	16	31.8	35%	6.6
28	NE																																	6.7	1.62	18	28.6	39%	5.4										NE
29	ARZ																																	5.2	1.98	22	36.6	31%	5.2
sheet1 (2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AH4:AM29	Expression	=COUNTIF($G$52:$G$66,$A4)>0	text	YES
AH7:AM7,AH9:AM9,AH11:AM11,AH13:AM13,AH15:AM15,AH17:AM17,AH19:AM19,AH21:AM21,AH23:AM23,AH25:AM25,AH27:AM27,AH29:AM29	Expression	=SUMPRODUCT((($AH6:$AM6)<($AH7:$AM7))^1)=6	text	NO
AH6:AM6,AH8:AM8,AH10:AM10,AH12:AM12,AH14:AM14,AH16:AM16,AH18:AM18,AH20:AM20,AH22:AM22,AH24:AM24,AH26:AM26,AH28:AM28	Expression	=SUMPRODUCT((($AH6:$AM6)>($AH7:$AM7))^1)=6	text	NO
AH5:AM5	Expression	=SUMPRODUCT((($AH4:$AM4)<($AH5:$AM5))^1)=6	text	NO
AH4:AM4	Expression	=SUMPRODUCT((($AH4:$AM4)>($AH5:$AM5))^1)=6	text	NO

 

[gtd526]

Try this.

Select AH4:AM29。
Add conditional formatting as the first Criteria
=COUNTIF($G$52:$G$66,$A4)>0
check "Stop If True" as True.

NFL score highlight-1.xlsx
	A																																	AH	AI	AJ	AK	AL	AM										AW
1	Week:																																		Points
2	Teams																																	NY/A	Pts/D	Pts/G	Sc %	3D Conversion	ANY/A										My Fav
3																																		15	16	17	18	19	20
4	LVR																																	5.9	2.3	24	50	40%	5.5										LVR
5	LAR																																	5.4	1.79	18	35.9	44%	4.3
6	NYJ																																	5.5	1.67	19	32.6	37%	5
7	BUF																																	6.7	2.63	28	47.5	56%	7										BUF
8	CLE																																	6	2.46	26	46.3	45%	5.9
9	CIN																																	5.9	1.88	23	37.5	47%	5.8										CIN
10	HOU																																	5.4	1.52	18	31.3	27%	4.9
11	DAL																																	6.1	1.6	18	35.6	30%	6.4										DAL
12	MIN																																	6	1.98	22	38.6	31%	5.6
13	DET																																	6.9	2.88	35	45.8	38%	7.5										DET
14	PHI																																	8.2	2.44	29	40	43%	8.1										PHI
15	NYG																																	4.6	1.69	19	35.6	32%	4
16	BAL																																	7	2.51	30	42.2	40%	7.3										BAL
17	PIT																																	5.3	1.43	18	30.4	37%	3.9
18	JAX																																	6.5	2.23	26	40.9	39%	7										JAX
19	TEN																																	6.6	1.79	19	31	38%	6.3
20	MIA																																	7.9	2.42	24	42.1	42%	7.9										MIA
21	LAC																																	7.2	2.09	23	36.4	41%	7.8
22	TB																																	6.2	1.65	20	34.8	35%	6.7										TB
23	SF																																	6.6	1.45	18	27.3	37%	6.3
24	CAR																																	5.2	1.47	20	31.1	26%	4.8
25	SEA																																	7.1	2.38	24	44.1	55%	7										SEA
26	KC																																	7	2.93	32	50	51%	7.9										KC
27	DEN																																	6.3	1.5	16	31.8	35%	6.6
28	NE																																	6.7	1.62	18	28.6	39%	5.4										NE
29	ARZ																																	5.2	1.98	22	36.6	31%	5.2
sheet1 (2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AH4:AM29	Expression	=COUNTIF($G$52:$G$66,$A4)>0	text	YES
AH7:AM7,AH9:AM9,AH11:AM11,AH13:AM13,AH15:AM15,AH17:AM17,AH19:AM19,AH21:AM21,AH23:AM23,AH25:AM25,AH27:AM27,AH29:AM29	Expression	=SUMPRODUCT((($AH6:$AM6)<($AH7:$AM7))^1)=6	text	NO
AH6:AM6,AH8:AM8,AH10:AM10,AH12:AM12,AH14:AM14,AH16:AM16,AH18:AM18,AH20:AM20,AH22:AM22,AH24:AM24,AH26:AM26,AH28:AM28	Expression	=SUMPRODUCT((($AH6:$AM6)>($AH7:$AM7))^1)=6	text	NO
AH5:AM5	Expression	=SUMPRODUCT((($AH4:$AM4)<($AH5:$AM5))^1)=6	text	NO
AH4:AM4	Expression	=SUMPRODUCT((($AH4:$AM4)>($AH5:$AM5))^1)=6	text	NO

Thank you.