VBA or Custom Conditional Format

[Stephen_IV]

Good Afternoon,

I wonder if someone could please help me with this. What I am trying to do is to Conditional format blank cells in between numbers. The illustration below shows that if I have a number before and after a blank cell then format the blank cells in between else leave blank. I hope that this is a clear explanation! Thanks Stephen!

Book4
	A	B	C	D	E	F	G	H	I
1	3/7	3/8	3/9	3/10	3/11	3/12	3/13	3/14	3/15
2	101	101	101	101	101	101	101	101	101
3			10	10	10	10	10	10	10
4	14	14	14	14	14	14	14	14	14
5	14	14	14	14	14	14	14	14	14
6			42	42	42		14	14	14
7	62		63	63	63	63	63	63	63
8				10
9				62	62	62	62	62	62
10					14	14	14	14	14
11					1	1	1	1	1
12					42	14		14	14
13						4	4	4	4
14	19
Sheet1

 

[Andrew Poulsom]

Select from b2 to the end of your data and use the Conditional Formatting formula:

=AND(LEN(B2)=0,ISNUMBER(A2),ISNUMBER(C2))

 

[Stephen_IV]

Thanks Andrew works perfectly! Thanks again!

 

[Stephen_IV]

Andrew is there a way to modify what you have given me. If you look at line 12 there could be multiple situations Thanks in advance Stephen!

Conditional Format Blank Cells in Between Numbers.xls
	A	B	C	D	E	F	G	H	I	J
1	3/7	3/8	3/9	3/10	3/11	3/12	3/13	3/14	3/15
2	101	101	101	101	101	101	101	101	101
3			10	10	10	10	10	10	10
4	14	14	14	14	14	14	14	14	14
5	14	14	14	14	14	14	14	14	14
6			42	42	42		14	14	14
7	62		63	63	63	63	63	63	63
8				10
9	71			62	62	62	62	62	62
10					14	14	14	14	14
11					1	1	1	1	1
12	71	71			42	14		14	14	X
13						4	4	4	4
14	19
Sheet1

 

[Andrew Poulsom]

Sorry, it's not clear what modification you want.

 

[Stephen_IV]

Andrew where I seemed to have an issue is with multiple cells blank.
Please look at row 9. Thanks Stephen.

Book1
	A	B	C	D	E	F	G	H	I
1	3/7	3/8	3/9	3/10	3/11	3/12	3/13	3/14	3/15
2	101	101	101	101	101	101	101	101	101
3			10	10	10	10	10	10	10
4	14	14	14	14	14	14	14	14	14
5	14	14	14	14	14	14	14	14	14
6			42	42	42		14	14	14
7	62		63	63	63	63	63	63	63
8				10
9	22			62	62	62	62	62	62
10					14	14	14	14	14
11					1	1	1	1	1
12	71	71		42	42	14		14	14
13						4	4	4	4
14	19	19		42		12		14	14
Sheet1

 

[Andrew Poulsom]

How about?

=AND(LEN(B2)=0,COUNT($A2:A2)>0,COUNT(C2:$I2)>0)

 

[Stephen_IV]

Perfect Andrew! Thank you so much!