Sub couleur()
Dim col As Long
With Sheets("Feuil1")
col = .Cells(38, Columns.Count).End(xlToLeft).Column
For i = 2 To col
If .Cells(150, i).Value = 7 Then
.Range(.Cells(9, i), .Cells(37, i)).Interior.Color = 9437183
Else
.Range(.Cells(9, i), .Cells(37, i)).Interior.Color = xlNone
End If
Next i
End With
End Sub