Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Fin: If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, [A2:A100]) Is Nothing Then
If Target = "" Then Range(Target.Address).Interior.Color = xlNone
Select Case UCase(Target)
Case "A": Range(Target.Address).Interior.Color = RGB(0, 112, 192)
Case "B": Range(Target.Address).Interior.Color = RGB(255, 0, 0)
Case "C": Range(Target.Address).Interior.Color = RGB(255, 255, 0)
Case "D": Range(Target.Address).Interior.Color = RGB(0, 176, 80)
Case "E": Range(Target.Address).Interior.Color = RGB(255, 192, 0)
End Select
End If
If Not Intersect(Target, [B2:B100]) Is Nothing Then
If Cells(Target.Row, "A") = "" Then Range(Target.Address).Interior.Color = xlNone
If Target = "" Then
Range(Target.Address).Interior.Color = xlNone
Else
Range(Target.Address).Interior.Color = Cells(Target.Row, "A").Interior.Color
End If
End If
Fin:
Application.ScreenUpdating = True
End Sub