add criteria to Conditional Formatting if >= 70%

[gtd526]

Hello,
Looking to add criteria to include if (D3:D32 >= .7), Existing code =COUNTIF($B$44:$B$76,$A3)
The code works in conditional formatting, I just want to add the criteria mentioned above.
Thank you

 

[StephenCrump]

What range are you conditionally formatting?

 

[gtd526]

What range are you conditionally formatting?

heres a copy

NBA.xlsm
	A	B	C	D	E	F
3	MEM	Memphis	14-5-0	0.737	13.3	7.9
4	OKC	Okla City	12-5-1	0.706	13.3	4.1
5	CLE	Cleveland	13-6-0	0.684	13.9	4.2
6	LAC	LA Clippers	12-6-0	0.667	5.6	4.5
7	ORL	Orlando	11-6-1	0.647	5.8	2.3
8	TOR	Toronto	12-7-1	0.632	-5.4	-0.4
9	LAL	LA Lakers	10-7-0	0.588	3.5	0.2
10	DAL	Dallas	10-7-0	0.588	8.6	3.6
11	HOU	Houston	11-8-0	0.579	7.5	2.3
12	POR	Portland	9-7-0	0.563	-7.1	-1.9
13	NYK	New York	8-7-1	0.533	9.9	0.7
14	CHA	Charlotte	10-9-0	0.526	-4.1	1.8
15	NOP	New Orleans	10-10-0	0.5	-5	-1.2
16	SAS	San Antonio	10-10-0	0.5	2.6	2.5
17	CHI	Chicago	9-9-0	0.5	-5	-1.5
18	MIA	Miami	8-9-0	0.471	2.8	-1.5
19	GSW	Golden State	9-11-0	0.45	0.3	-3
20	DEN	Denver	7-9-1	0.438	3	-0.4
21	IND	Indiana	6-8-1	0.429	1.8	-2.2
22	DET	Detroit	7-10-0	0.412	-2.9	-1.5
23	ATL	Atlanta	7-10-0	0.412	-1.2	-2.3
24	UTA	Utah	6-9-0	0.4	-9.3	-3.3
25	WAS	Washington	8-12-0	0.4	-11.7	-1.8
26	BRK	Brooklyn	6-10-0	0.375	-8.7	-3.5
27	BOS	Boston	7-12-0	0.368	10.2	-0.6
28	SAC	Sacramento	7-13-2	0.35	2	-3.1
29	MIL	Milwaukee	5-11-1	0.313	3.5	-3.8
30	PHX	Phoenix	5-13-0	0.278	0.8	-2.8
31	PHI	Philadelphia	4-11-0	0.267	-5.5	-5.7
32	MIN	Minnesota	4-12-1	0.25	2.6	-3.4
33
34
35
36		4			NBA ATS Records In Away Games | BetIQ (teamrankings.com)
37		4			ATS Record: The number of ATS covers, no-covers, and pushes
38					Cover %: The percentage of time the team covered, net of pushes
39					MOV: The average margin of victory (negative in losses)
40					ATS +/-: The average amount of points that the team covers the spread by
41	formula below determines Highlights Above
42	HOME TEAMS @ Favs				AWAY TEAMS @ Favs
43	IF(ISODD(ROW(Favs!$A4)),Favs!$A4,"")				IF(ISEVEN(ROW(Favs!$A4)),Favs!$A4,"")
44						OKC
45		CLE
46						CHI
47		IND
48						TOR
49		NYK
50						WAS
51		PHI
52						DET
53		BRK
54						POR
55		NOP
56						LAC
57		DEN
58						SAS
59		MIL
60						0
61		0
62						0
63		0
64						0
65		0
66						0
67		0
68						0
69		0
70						0
71		0
72						0
73		0
ATS Trends

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:F32	Expression	=COUNTIF($B$44:$B$76,$A3)	text	NO

 

[Alex Blakenburg]

Try

 =COUNTIF($B$44:$B$76,$A3)*($D3>=0.7)

 

[gtd526]

Try

 =COUNTIF($B$44:$B$76,$A3)*($D3>=0.7)

works. thank you.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.