Sub color_cells()
Dim i As Long, r1 As Range, r2 As Range
Set r1 = Range("H:H")
For Each cell In r1
If IsEmpty(cell) Then GoTo nextcell:
If cell.Value = "Envoyer le colis" Then Range("A" & cell.Row & ":G" & cell.Row).Interior.Color = vbYellow
nextcell:
Next cell
End Sub