Highlighting Macro

Hi Try this

Sub YellowRows()
    Dim i As long

    For i = 14 To Rows.Count Step 14
        Rows(i).Interior.ColorIndex = 6
    Next
End Sub

This will do the whole work sheet you might want to cut it down a little