For Each c In Range("C3: M35")
If c.Value <> "" Then
If InStr(c, "OUI") Then
c.Font.Color = vbGreen
If c.Column = 3 And InStr(c.Offset(, 1), "OUI") _
Then c.EntireRow.Interior.ColorIndex = 7 'lavande ??
ElseIf InStr(c, "NON") Then
c.Font.Color = vbRed
End If
End If
Next