Forum Discussion

QianHK's avatar
QianHK
Frequent Visitor
6 years ago

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

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!

Need Help

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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's avatar
      QianHK
      Frequent Visitor
      6 years ago

      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.