Conditional formatting: mark blank cells between two non-blank cells

[QianHK]

Hi all, 

I have a question and please help. 

I would like to fill blank cells between two non-blank cells the same colour, when there are two or more blank cells show together. 

For example, I would like the two blank cells to show red background colour as their neighbouring cells. 

could you help?

Thanks!

[mwegener]

Hi @QianHK ,

can you mark the start point with +1 and the end point with -1?

With a running total you could then determine the cells between this values.

[QianHK]

Hi, thanks for your input.

However, I can't change the numbers in cells. They are counts of certain values. If they are not blank,  they are always bigger or equal to 1.