Conditional Formatting Formula to highlight empty cells between cells with value

[apor]

I want to use conditional formatting to highlight cells with no value if they sit between cells with value.

I have tried this rule however it is not giving me any results:

=" =AND(B2="""",SUM($B2:B2)>0,SUM(B2:$CC2)>0)"

	bb	cc	dd	ee	ff	gg	hh
A	1​		1​	1​			1​
B	1​	1​	1​		1​	11​	1​
C			1​	11​		11​	1​
D	1​	1​	1​	1​
E		1​				1​	1​
F	1​	1​			1​
G	1​	1​	1​	1​	1​	1​

 

[awoohaw]

Not sure if you want column A considered in the blankness or not, but try this;

Mr excel questions 42.xlsm
	A	B	C	D	E	F	G	H
1		bb	cc	dd	ee	ff	gg	hh
2	A	1		1	1			1
3	B	1	1	1		1	11	1
4	C			1	11		11	1
5	D	1	1	1	1
6	E		1				1	1
7	F	1	1			1
8	G	1	1	1	1	1	1
apor

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:H8	Expression	=AND(SUM(--($A2:A2<>""))>0,SUM(--(C2:$H2<>""))>0,B2="")	text	NO

 

[Fluff]

Duplicate to: highlighting cells with no value if they are between cells with value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.