bonjour
essaye comme ceci :
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C8
38")) Is Nothing Then
For Each cell In Target
If cell.Value = "CB" Then
Rows(Target.Row).Interior.ColorIndex = 33
Target.Font.ColorIndex = 0
ElseIf cell.Value = "Ch" Then
Rows(Target.Row).Interior.ColorIndex = 41
Target.Font.ColorIndex = 0
ElseIf cell.Value = "Pr" Then
Rows(Target.Row).Interior.ColorIndex = 11
Target.Font.ColorIndex = 2
ElseIf cell.Value = "Vir" Then
Rows(Target.Row).Interior.ColorIndex = 50
Target.Font.ColorIndex = 0
ElseIf cell.Value = "Ent" Then
Rows(Target.Row).Interior.ColorIndex = 40
Target.Font.ColorIndex = 0
ElseIf cell.Value = "" Then
Rows(Target.Row).Interior.ColorIndex = 0
Target.Font.ColorIndex = 0
End If
Next
End If
End Sub
Salut
Hervé