Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Or Target.Column = 2 Then Exit Sub
If Not Intersect([planning], Target) Is Nothing Then
Application.EnableEvents = False
Selection.Value = Target
Application.EnableEvents = True
On Error Resume Next
Selection.Interior.ColorIndex = [couleurs].Find(Target, LookAt:=xlWhole).Interior.ColorIndex
End If
End Sub