Counting not-coloured cells that fall in-between highlighted cells in a column

[Gracemusa]

Please help. what formula or function can i use for excel to count for me un-coloured cells that are in between highlighted cells in a column (and return each time it gets to a highlighted cell). i dont need a total sum of those uncoloured cells in the column. I need a subtotal count for each section between highlighted cells as demonstrated in the image uploaded. Thanking you in advance for helping!

 

[kevin9999]

I'm not aware of any formula or function (except a UDF) that would achieve what you want. If you're open to a VBA solution, then try this:

Option Explicit
Sub CountBetween()
    Dim ws As Worksheet, c As Range, i As Long
    Set ws = Worksheets("Sheet1")   '<~~ *** Change sheet name if needed ***
    For Each c In ws.Range("C3", ws.Cells(Rows.Count, "C").End(xlUp))
        If c.Interior.ColorIndex = xlNone Then
            i = i + 1
            If c.Offset(1).Interior.ColorIndex <> xlNone Then
                c.Offset(0, 2).Value2 = i
                i = 0
            End If
        End If
    Next c
End Sub