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!