Forum Discussion
QianHK
6 years agoFrequent Visitor
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 wou...
mwegener
6 years agoMost Valuable Professional
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
6 years agoFrequent Visitor
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.