Private Sub Worksheet_Change(ByVal Target As Range)
Dim Li As Integer, Col As Byte, C As Byte
If Target.Count > 1 Then Exit Sub
Li = Target.Row
If Not Intersect(Target, Range("H" & Li & ":CF" & Li)) Is Nothing Then
For Col = 14 To 80 Step 6
If Cells(Li, Col) < Cells(Li, "H") Then C = C + 1
Next
Cells(Li, "G") = IIf(C = 0, "EN STOCK", "RUPTURE")
End If
End Sub