Conditional Formatting for Matching Odd Rows only

[gtd526]

Hello,
These Highlights are the result for current Conditional Formatting.
Looking to Match for Odd Rows.

NBA.xlsm
	A	B	C	D	E	F
2		Team	ATS Record	Cover %	MOV	ATS +/-
3	ORL	Orlando	29-13-0	0.691	8.9	5.4
4	HOU	Houston	27-13-1	0.675	5.3	4.4
5	OKC	Okla City	28-15-0	0.651	13.1	6.2
6	UTA	Utah	24-17-0	0.585	1.7	3.5
7	PHI	Philadelphia	25-19-0	0.568	4.7	-0.3
8	IND	Indiana	23-18-2	0.561	6.9	3.3
9	BOS	Boston	23-18-2	0.561	14.7	4.1
10	SAS	San Antonio	22-19-0	0.537	-4.1	1.2
11	BRK	Brooklyn	20-18-3	0.526	1.3	1.6
12	NYK	New York	22-20-1	0.524	5.9	1.3
ATS Trends

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:A32,D3:D32,E3:E32,F3:F32	Expression	=AND(MATCH($A3,Favs!$A$4:$A$33,0),$D3>=0.546)	text	NO

Where we want to Match using ODD Rows only. ie Only HOU will Match (above).

NBA.xlsm
	A	B
3	Team	ATS
4	PHI	3.5
5	NYK	-3.5
6	ORL	4.5
7	CLE	-4.5
8	IND	-4.5
9	MIL	4.5
10	BRK	5
11	HOU	-5
12
13
14
15
16
17
18
19
Favs

 

[etaf]

=AND(MATCH($A3,Favs!$A$4:$A$33,0),$D3>=0.546)
how about
=ISODD(ROW(A3))

=AND(MATCH($A3,Favs!$A$4:$A$33,0),$D3>=0.546,=ISODD(ROW($A3)))

 

[gtd526]

=AND(MATCH($A3,Favs!$A$4:$A$33,0),$D3>=0.546)
how about
=ISODD(ROW(A3))

=AND(MATCH($A3,Favs!$A$4:$A$33,0),$D3>=0.546,=ISODD(ROW($A3)))

The ISODD(ROW...is for Favs!$A$4:$A$33

 

[etaf]

so you only want to match if the lookup a3 is on an odd row in the column A4;A33
so it matches as its in row 11 at the moment - but if HOU was in cell 12 , then no match

not sure i know how to do that exactly, but see if thats what you want

 

[gtd526]

so you only want to match if the lookup a3 is on an odd row in the column A4;A33
so it matches as its in row 11 at the moment - but if HOU was in cell 12 , then no match

not sure i know how to do that exactly, but see if thats what you want

Yes. Match the cell if its in an ODD Row in Favs!$A$4:$A$33.