How do I write the conditional formula to highlight multiple cells when the adjacent cell is >=1?

[arthurz11]

I selected the range A1:B5 and on the conditional formatting I wrote the formula =IF($D$1>=1,1,0) but it still highlighted all the cells. How do I write the formula so it would look like in cells range A8:B12???

 

[SunnyAlv]

i think u can write without if function

like this

 

[Eric W]

Book2
	A	B	C	D
1	-1	-2		1
2	-3	-4		0
3	-5	-6		0
4	-7	-8		1
5	-9	-10		0
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B5	Expression	=$D1>=1	text	NO

 

[arthurz11]

Book2
	A	B	C	D
1	-1	-2		1
2	-3	-4		0
3	-5	-6		0
4	-7	-8		1
5	-9	-10		0
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B5	Expression	=$D1>=1	text	NO

Thank you! So far so good.

 

[arthurz11]

i think u can write without if function

like this
View attachment 116096

I try it but it only highlighted cells A1 and A4 using =D1>=1. Eric W's formula worked. It needed the $ in front of D1 to highligh A1, B1, A4, and B4 Thanks!