Private Sub Worksheet_Change(ByVal Target As Range) Dim Entrée As String With Target Entrée = UCase(.Value) Select Case Entrée Case "A" .Interior.Color = vbCyan Case "B" .Interior.Color = vbYellow Case "C" .Interior.Color = vbGreen Case "D" .Interior.Color = vbGreen Case "E" .Interior.Color = vbBlue Case Else .Interior.Color = vbWhite End Select End With End Sub
With Target If Selection.Count > 1 Then .Interior.Color = vbWhite Exit Sub End If Select Case Target.Value Case "A", "a" .Interior.Color = vbCyan Case "B", "b" .Interior.Color = vbYellow Case "C", "c" .Interior.Color = vbGreen Case "D", "d" .Interior.Color = vbRed Case "E", "e" .Interior.Color = vbBlue Case Else .Interior.Color = vbWhite End Select End With End Sub