Sub colore()
i = 8
While i < 366
Set avant = Range("B" & i).Offset(-6, 0).Resize(6, 1)
Set apres = Range("B" & i).Offset(1, 0).Resize(6, 1)
If Cells(i, 2) <> "" Then
If Application.WorksheetFunction.CountA(avant) = 0 And Application.WorksheetFunction.CountA(apres) = 0 Then
Union(avant, apres, Cells(i, 2)).Interior.ColorIndex = 6
End If
End If
i = i + 1
Wend
End Sub