Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name Like "sem. *" Then
'c'est à partir d'ici que je ne sais pas si on peux utiliser le mot Target
For j = 2 To 6
With Cells(2, j)
If .Value = "maladie" Then
.Interior.ColorIndex = 46
ElseIf .Value = "autoformation" Then
.Interior.ColorIndex = 37
ElseIf .Value = "ferie" Then
.Interior.ColorIndex = 15
ElseIf .Value = "divers" Then
.Interior.ColorIndex = 35
ElseIf .Value = "rtt" Then
.Interior.ColorIndex = 36
ElseIf .Value = "conges" Then
.Interior.ColorIndex = 6
End If
End With
Next j
End If
End Sub