Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Target
If c.Value = "EX" Then c.Interior.ColorIndex = 36
If c.Value = "ET" Then c.Interior.ColorIndex = 34
If c.Value = "VA" Then c.Interior.ColorIndex = 44
If c.Value <> "EX" And c.Value <> "BB" And c.Value <> "ET" _
And c.Value <> "VA" Then c.Interior.ColorIndex = 2
Next c
End Sub