Private Sub Worksheet_Change(ByVal Target As Range)
With ActiveCell
Select Case UCase(.Value)
Case Is = ''
.Interior.ColorIndex = 2
Case Is = 'A'
.Interior.ColorIndex = 4
Case Is = 'B'
.Interior.ColorIndex = 4
Case Is = 'C'
.Interior.ColorIndex = 8
Case Is = 'TEST'
.Interior.ColorIndex = 8
End Select
End With
End Sub