I have a table with a number of columns and each column row is populated by either a 1 (one) or a 0 (zero).

Each column could have a number of 1's or 0's in successive row cells and each column will vary.

What I would like to do is apply a conditional formatting formula to highlight a number of 0's in a column.

If for instance there are five 0's in succession it would highlight that group of cells in the column yellow.

If there are 10 0's in succession, it would highlight that group of cells in the column red and so on.

I think it might involve using the FREQUENCY command but I am not sure how to go about applying it.

Everything I have tried with my limited knowledge of Excel formulas has failed even after reading everything I could find.

Is this actually possible to do what I am asking?

Thanks
Bill