Conditional Format Compare Ranges

[ozbeachbum]

I am looking for a formula that will work in Conditional Formatting where;
Column B shows Red where there is an entry in column D or H and Zero in columns E or J.
If there are no entries in columns D or H - E or J Red would not show.

341204 compare m-r X2.xlsx
	A	B	C	D	E	F	G	H	I	J	K
2				Description		Qty		Description		Qty
3
4				TEST 0		1		TEST 10		8
5				TEST 1		3		TEST 11		3
6				TEST 2		6		TEST 12		5
7				TEST 3		5		TEST 13		0
8				TEST 4		8		TEST 14		9
9				TEST 5		9		TEST 15		2
10				TEST 6		2		TEST 16		0
11				TEST 7		0		TEST 17		4
12				TEST 8		19		TEST 18		19
13				TEST 9		0		TEST 19		5
Blank

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D		F		H		J
1
2				Description		Qty		Description		Qty
3
4				TEST 0		1		TEST 10		8
5				TEST 1		3		TEST 11		3
6				TEST 2		6		TEST 12		5
7				TEST 3		5		TEST 13		0
8				TEST 4		8		TEST 14		9
9				TEST 5		9		TEST 15		2
10				TEST 6		2		TEST 16		0
11				TEST 7		0		TEST 17		4
12				TEST 8		19		TEST 18		19
13				TEST 9		0		TEST 19		5
14
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:B100	Expression	=OR(AND(D4<>"",F4=0),AND(H4<>"",J4=0))	text	NO

 

[ozbeachbum]

Thanks for your help again, works perfectly.
I was trying AND(OR and only getting a result for H & j, I did realise that swapping them about would do the trick.
You have helped grow my knowledge.

 

[Fluff]

You're welcome & thanks for the feedback.