Conditional format cells only that contain a sequence of blanks

Hi all, I need some help trying to nut out a conditional formating formula.

I need to only highlight cells that contain 3 or more blanks in sequence in a row (range E2:O2)

The desired outcome is to highlight the cell A2 as row A has 3 or more blanks in a row. Following this A6 will highlight but the remaining A cells will remain not highlighted.

If any advice can be given for the forula to use it would be amazing!


E.g. below

By: Sean

Leave a Reply

Your email address will not be published. Required fields are marked *