What I understand is count the max consecutive font color except the cell with no value and font colorindex = default color.(xlAutomatic)

So it will count consecutive any font color.

Completely different in logic from the other code.