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","")),"")

 

[HongRu]

step1. select cells(AH4:AM4), add Conditional Formatting below, and set the format you need

=AH4>AH5

step2. select cells(AH5:AM5), add Conditional Formatting below, and set the format you need

=AH5>AH4

step3. select cells(AH4:AM5) and copy to cells(AH6:AM29)
Done.

活頁簿2
	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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
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	=AH7>AH6	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	=AH6>AH7	text	NO
AH5:AM5	Expression	=AH5>AH4	text	NO
AH4:AM4	Expression	=AH4>AH5	text	NO

 

[gtd526]

step1. select cells(AH4:AM4), add Conditional Formatting below, and set the format you need

=AH4>AH5

step2. select cells(AH5:AM5), add Conditional Formatting below, and set the format you need

=AH5>AH4

step3. select cells(AH4:AM5) and copy to cells(AH6:AM29)
Done.

活頁簿2
	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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
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	=AH7>AH6	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	=AH6>AH7	text	NO
AH5:AM5	Expression	=AH5>AH4	text	NO
AH4:AM4	Expression	=AH4>AH5	text	NO

I've added your conditional formatting, but it only changes the colors I've chosen.
Is there a way to ONLY highlight if AH:AM are ALL greater than the alternate cell?
It should work for BUF, DET, PHI, BAL, MIA, SEA, KC

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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AH7:AM7,AH9:AM9,AH11:AM11,AH13:AM13,AH15:AM15,AH17:AM17,AH19:AM19,AH21:AM21,AH23:AM23,AH25:AM25,AH27:AM27,AH29:AM29,AH31:AM31,AH33:AM33,AH35:AM35	Expression	=AH7>AH6	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,AH30:AM30,AH32:AM32,AH34:AM34	Expression	=AH6>AH7	text	NO
AH5:AM5	Expression	=AH5>AH4	text	NO
AH4:AM4	Expression	=AH4>AH5	text	NO
A3	Cell	does not contain a blank value	text	NO

 

[HongRu]

try to replace
AH7>AH6 by SUMPRODUCT((($AH4:$AM4)>($AH5:$AM5))^1)=6
and
AH6>AH7 by SUMPRODUCT((($AH4:$AM4)<($AH5:$AM5))^1)=6

NFL score highlight.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
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 to replace
AH7>AH6 by SUMPRODUCT((($AH4:$AM4)>($AH5:$AM5))^1)=6
and
AH6>AH7 by SUMPRODUCT((($AH4:$AM4)<($AH5:$AM5))^1)=6

NFL score highlight.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
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

Perfect. Thank you.

 

[gtd526]

Perfect. Thank you.

What if I want to do the same with non-adjacent columns? O:P, Y and N > .525

NBA.xlsm
	N	O	P	Q	R	S	T	U	V	W	X	Y
2	Cover2 %	ATS +/-	MOV2	MOV2 >ATS	MOV	MOV	Rebounds	FG%	FT%	Asst /	Asst /	Pts @ Half
3		Mov2				>ATS				Tover	FGM
4	50%	-1.7	-0.6	-7.1	-1.6	-8.1	53.3	54%	74.2%	1.44	57.9%	52.9
5	54%	0.2	-4.5		-6.6		51	53%	79.0%	1.28	54.3%	54.2
6	55%	-1.3	-7.7		-5.8		54.4	50%	73.7%	1.72	60.8%	54.5
7	42%	-2.2	2.4	-7.1	0.8	-8.7	47.6	57%	79.6%	1.77	63.3%	57.4
8	40%	-0.1	0.3		0.4		52.3	52%	82.0%	1.78	54.9%	58.2
9	30%	-3.3	-1.0	-3	-1.3	-3.3	55.5	51%	79.3%	1.67	56.4%	59.8
10	36%	-1	-5.7		-1.0		53.4	53%	79.9%	1.70	58.6%	59.4
11	67%	1.5	4.6	-3.9	1.1	-7.4	52.6	51%	77.4%	1.74	56.8%	55.7
12	44%	0.8	-3.3		-1.5		52.8	53%	76.9%	1.86	59.6%	55.8
13	50%	0.9	1.4	-4.1	-1.3	-6.8	49.6	53%	82.5%	1.67	59.2%	55.5
14	69%	3.1	-2.8		-0.7		52.6	53%	79.2%	1.70	55.1%	57.2
15	73%	5.9	9.3	1.8	1.9	-5.6	58.8	53%	70.4%	1.66	56.9%	58.8
16	70%	3.1	0.9		4.1		50.5	57%	79.5%	1.86	65.2%	61.3
17	64%	1.1	8.1	2.1	4.8	-1.2	57.5	53%	72.6%	1.66	60.6%	57.3
18	54%	0.2	-4.7		-1.0		53	53%	79.1%	1.75	67.5%	55.8
19	31%	-7.3	-2.4	-6.9	-1.2	-5.7	51.4	55%	79.2%	1.59	62.7%	57.5
20	54%	2.1	-7.2		-7.0		52	51%	77.4%	1.54	56.2%	55.6
21	58%	5.1	9.3	-1.2	7.0	-3.5	53	55%	79.4%	1.86	62.7%	57.3
22	17%	-10.3	-8.6		1.0		50.7	57%	79.1%	1.76	69.5%	60
23	58%	3.3	6.3	-1.2	2.1	-5.4	52.6	56%	77.9%	1.69	63.4%	60.3
24	58%	1.1	4.8	3.3	8.1	6.6	49.1	59%	84.4%	1.96	63.4%	63.4
25	64%	3.6	10.9		7.2		52	55%	80.5%	2.05	63.5%	58.1
26
27
28
29
30
31
32
33
Favs

Cell Formulas
Range	Formula
N4:N33	N4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BL$65,4,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BL$32,4,0),2)),"")
O4:O33	O4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BN$65,6,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BN$32,6,0),2)),"")
P4:P33	P4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BM$65,5,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BM$32,5,0),2)),"")
Q4:Q33,S4:S33	Q4	=IF(AND($B4<0,P4=""),"",IF(AND($B4<0,P4<0),$B4+P4,IF(AND($B4<0,P4>0),P4-ABS($B4),"")))
R4:R33	R4	=IFERROR(VLOOKUP($A4,TeamRankings!$AL$3:$AP$32,5,0),"")
T4:T33	T4	=IFERROR(VLOOKUP($A4,TeamRankings!$FN$3:$FQ$32,4,0),"")
U4:U33	U4	=IFERROR(VLOOKUP($A4,TeamRankings!$BV$3:$BY$32,4,0),"")
V4:V33	V4	=IFERROR(VLOOKUP($A4,TeamRankings!$ED$3:$EG$32,4,0),"")
W4:W33	W4	=IFERROR(VLOOKUP($A4,TeamRankings!$J$3:$M$32,4,0),"")
X4:X33	X4	=IFERROR(VLOOKUP($A4,TeamRankings!$S:$V,4,0),"")
Y4:Y33	Y4	=IFERROR(VLOOKUP($A4,TeamRankings!$DU$3:$DX$32,4,0),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O6:P6,O8:P8,O10:P10,O12:P12,O14:P14,O16:P16,O18:P18,O20:P20,O22:P22,O24:P24,O26:P26,O28:P28,O30:P30,O32:P32	Expression	=SUMPRODUCT((($O6:$P6)>($O7:$P7))^1)=2	text	NO
O7:P7,O9:P9,O11:P11,O13:P13,O15:P15,O17:P17,O19:P19,O21:P21,O23:P23,O25:P25,O27:P27,O29:P29,O31:P31,O33:P33	Expression	=SUMPRODUCT((($O6:$P6)<($O7:$P7))^1)=2	text	NO
K4:O33	Expression	=$A4=""	text	NO
O4:P4	Expression	=SUMPRODUCT((($O4:$P4)>($O5:$P5))^1)=2	text	NO
O5:P5	Expression	=SUMPRODUCT((($O4:$P4)<($O5:$P5))^1)=2	text	NO
N4:N33	Expression	=$N4>0.525	text	NO
U4:U33	Cell	contains a blank value	text	NO
Q4:Q33,AG4:AG33,AI4:AK33	Expression	=AND($Q4<>"",$Q4>0,ISNUMBER($AI4),$AI4>=0.6,ISNUMBER($AJ4),$AJ4>=0.6,ISNUMBER($AK4),$AK4>=0.6,$AN4<=$AN$1)	text	NO
N4:N33,L4:L33,W4:X33,AI4:AK33	Expression	=AND($A4=$AG4,$N4<>"",$N4>=0.65,$L4<>"",$L4>=0.65,ISNUMBER($AI4),$AI4>=0.7,ISNUMBER($AJ4),$AJ4>=0.7,ISNUMBER($AK4),$AK4>=0.7,$AN4<=$AN$1)	text	NO
Q4:Q33,S4:S33,AG4:AG33,AI4:AK33	Expression	=AND($Q4<>"",$Q4>0,$S4<>"",$S4>0,ISNUMBER($AI4),$AI4>=0.6,ISNUMBER($AJ4),$AJ4>=0.6,ISNUMBER($AK4),$AK4>=0.6,$AN4<=$AN$1)	text	NO
S4:S33,AG4:AG33,AI4:AK33	Expression	=AND($S4<>"",$S4>0,ISNUMBER($AI4),$AI4>=0.6,ISNUMBER($AJ4),$AJ4>=0.6,ISNUMBER($AK4),$AK4>=0.6,$AN4<=$AN$1)	text	NO
Q4:Q33,S4:S33,AG4:AG33	Expression	=AND($A4=$AG4,$Q4<>"",$Q4>0,$S4<>"",$S4>0,$AN4<=$AN$1)	text	NO
S4:S33,AG4:AG33	Expression	=AND($S4<>"",$S4>0,$AN4<=$AN$1)	text	NO
Q4:Q33,AG4:AG33	Expression	=AND($Q4<>"",$Q4>0,$AN4<=$AN$1)	text	NO
R4:R33	Expression	=AND($R4>=LARGE($R$4:$R$33,3),$R4<>"")	text	NO
W4:W33	Expression	=AND($W4>=1.85,$W4<>"")	text	NO
X4:X33	Expression	=AND($X4>=0.65,$X4<>"")	text	NO
T4:T33	Cell Value	top 1 values	text	NO
U4:U33	Cell Value	top 1 values	text	NO
V4:V33	Cell Value	top 1 values	text	NO
Y4:Y33	Cell Value	top 1 values	text	NO
U2	Expression	=$AO$3="032"	text	NO
T2	Expression	=$AO$3="030"	text	NO
Y2	Expression	=$AO$3="025"	text	NO
T2:V2	Expression	=$AO$3="018"	text	NO
L2,L3:O3	Expression	=$AY$3="020"	text	NO
T2:V2	Expression	=$AY$3="018"	text	NO
X3,W2:AB2,AB3,Z3	Expression	=$AO$3="034"	text	NO
X3,W2:AB2,AB3,Z3	Expression	=$AY$3="034"	text	NO
Q2:Q3	Cell	does not contain a blank value	text	NO
S2:S3	Cell	does not contain a blank value	text	NO
AB4:AC33,T4:Z33	Expression	=T4=MAX(OFFSET(T$4,FLOOR(ROW(T4)-ROW(T$4),2),0,2,1))	text	NO
R4:R33	Expression	=R4=MAX(OFFSET(R$4,FLOOR(ROW(R4)-ROW(R$4),2),0,2,1))	text	NO
T4:AC33	Expression	=AND(ISODD(ROW(T4)),T4=T3)	text	NO
T4:AC33	Expression	=AND(ISEVEN(ROW(T4)),T4=T5)	text	NO
M4:M33,O4:S33	Cell Value	>0	text	NO
M4:M33,O4:S33	Cell Value	<0	text	NO
N4:N33	Expression	=$N4="Tie"	text	NO

 

[HongRu]

What if I want to do the same with non-adjacent columns? O:P, Y and N > .525

I don't really understand what you need.
Maybe you can explain more clearly.

 

[gtd526]

I don't really understand what you need.
Maybe you can explain more clearly.

I want to highlight if all are True.
O:P and Y:Y are greater than the opposing cell (cell above or below), and N:N is greater than .525.
Its the same as the above posts (which you solved), using different columns with different criteria in N:N.
2 lines per game, 4,5--6,7--8,9--10,11 thru Row 33
I have your conditional formatting in O:P. Just need extend that to Y:Y and N:N > .525
UTA should be highlighted.

NBA.xlsm
	A													N	O	P	Q	R	S	T	U	V	W	X	Y								AG
1
2	12/8													Cover2 %	ATS +/-	MOV2	MOV2 >ATS	MOV	MOV	Rebounds	FG%	FT%	Asst /	Asst /	Pts @ Half
3	Team														Mov2				>ATS				Tover	FGM
4	LAC													46%	-2.4	-0.9		-1.7		53.7	54%	74.0%	1.44	58.2%	52.8
5	MIA													25%	-4.5	0.1	-4.9	-1.9	-6.9	49.4	52%	84.0%	1.65	61.5%	56.2								MIA
6	HOU													47%	0.2	-9.3	-11.3	-6.3	-8.3	55.5	51%	78.1%	1.19	54.8%	56								HOU
7	SAN													39%	-6.5	-11.1		-11.8		50.5	52%	72.2%	1.70	66.5%	55.1
8	DEN													40%	-5	-4.1		1.0		49.9	57%	74.7%	1.83	65.1%	60.4
9	POR													50%	1.5	2.5	1.5	-0.7	-1.7	51.4	54%	76.7%	1.56	60.6%	56								POR
10	UTA													57%	2.7	-1.4		2.1		52.4	56%	78.0%	1.69	63.1%	60.6								UTA
11	DET													55%	-1.4	-6.8		-7.0		51.9	51%	77.4%	1.53	56.0%	55.1
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Sheet2

Cell Formulas
Range	Formula
A2	A2	=TODAY()
N4:N33	N4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BL$65,4,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BL$32,4,0),2)),"")
O4:O33	O4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BN$65,6,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BN$32,6,0),2)),"")
P4:P33	P4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$BI$36:$BM$65,5,0),2),ROUND(VLOOKUP($A4,TeamRankings!$BI$3:$BM$32,5,0),2)),"")
Q4:Q33,S4:S33	Q4	=IF(AND($B4<0,P4=""),"",IF(AND($B4<0,P4<0),$B4+P4,IF(AND($B4<0,P4>0),P4-ABS($B4),"")))
R4:R33	R4	=IFERROR(VLOOKUP($A4,TeamRankings!$AL$3:$AP$32,5,0),"")
T4:T33	T4	=IFERROR(VLOOKUP($A4,TeamRankings!$FN$3:$FQ$32,4,0),"")
U4:U33	U4	=IFERROR(VLOOKUP($A4,TeamRankings!$BV$3:$BY$32,4,0),"")
V4:V33	V4	=IFERROR(VLOOKUP($A4,TeamRankings!$ED$3:$EG$32,4,0),"")
W4:W33	W4	=IFERROR(VLOOKUP($A4,TeamRankings!$J$3:$M$32,4,0),"")
X4:X33	X4	=IFERROR(VLOOKUP($A4,TeamRankings!$S:$V,4,0),"")
Y4:Y33	Y4	=IFERROR(VLOOKUP($A4,TeamRankings!$DU$3:$DX$32,4,0),"")
AG4,AG32,AG30,AG28,AG26,AG24,AG22,AG20,AG18,AG16,AG14,AG12,AG10,AG8,AG6	AG4	=IFS(AF4>AF5,$A4,AF4<AF5,"",AND(AF4=0,AF5=0),"",AF4=AF5,"Tie")
AG5,AG33,AG31,AG29,AG27,AG25,AG23,AG21,AG19,AG17,AG15,AG13,AG11,AG9,AG7	AG5	=IFS(AF5>AF4,$A5,AF5<AF4,"",AND(AF5=0,AF4=0),"",AF5=AF4,"Tie")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O6:P6,O8:P8,O10:P10,O12:P12,O14:P14,O16:P16,O18:P18,O20:P20,O22:P22,O24:P24,O26:P26,O28:P28,O30:P30,O32:P32	Expression	=SUMPRODUCT((($O6:$P6)>($O7:$P7))^1)=2	text	NO
O7:P7,O9:P9,O11:P11,O13:P13,O15:P15,O17:P17,O19:P19,O21:P21,O23:P23,O25:P25,O27:P27,O29:P29,O31:P31,O33:P33	Expression	=SUMPRODUCT((($O6:$P6)<($O7:$P7))^1)=2	text	NO
O4:P4	Expression	=SUMPRODUCT((($O4:$P4)>($O5:$P5))^1)=2	text	NO
O5:P5	Expression	=SUMPRODUCT((($O4:$P4)<($O5:$P5))^1)=2	text	NO

 

[HongRu]

Try
put the formula in N4 conditonal format

=AND($N4>0.525,$O4>$O5,$P4>$P5,$Y4>$Y5)

in N5

=AND($N5>0.525,$O4<$O5,$P4<$P5,$Y4<$Y5)

then
copy N4:N5 format only to what you want.

I think this formula is much easier to understand and amend.
HTH

 

[gtd526]

Try
put the formula in N4 conditonal format

=AND($N4>0.525,$O4>$O5,$P4>$P5,$Y4>$Y5)

in N5

=AND($N5>0.525,$O4<$O5,$P4<$P5,$Y4<$Y5)

then
copy N4:N5 format only to what you want.

I think this formula is much easier to understand and amend.
HTH

Everything is working well. Thank you for the formulas.