Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Range
Set x = Range("A1:A" & Range("A65536").End(xlUp).Row)
For Each x In x
If x = "contractuel ORG" Then
x.Interior.ColorIndex = 3
Else
x.Interior.ColorIndex = xlNone
End If
Next x
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range
For Each C In Range("Tab") [COLOR=Green]'Insertion/Noms/Définir =DECALER(Feuil1!$A$2;;;NBVAL(Feuil1!$A:$A)-1)[/COLOR]
C.Interior.ColorIndex = IIf(C.Value = "contractuel ORG", 3, XlNone)
Next C
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
For Each C In Range("Tab")
If C.Offset(0, 1) <> "" Then
Range(C.Offset(0, 2), C.Offset(0, 2).End(xlToRight)).Font.ColorIndex = IIf(C.Value = "contractuel ORG", 3, 0)
End If
Next C
End Sub