More conditional formats needed!

Here's a quick example of how this could be done:

I have assumed that you want to apply the conditions only between A1:B6. I have stipulated as follows:

If the cell equals "a" then make red
if "b" then make green
if "c" make grey
if "d" make pink
if "e" make blue

To test this open a new workbook. Go to the VBE (Alt+F11).
Project - VBAProject double click the desired sheet and paste this code into the page area (big white pane on the right)

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo Finish

With Target
    If .Row < 7 And .Column < 3 Then
        Select Case .Value
            Case "a"
                .Font.ColorIndex = 3
            Case "b"
                .Font.ColorIndex = 10
            Case "c"
                .Font.ColorIndex = 16
            Case "d"
                .Font.ColorIndex = 22
            Case "e"
                .Font.ColorIndex = 28
        End Select
    End If
End With

Finish: Exit Sub

End Sub

Note, the example attached changes only font color, but we can actually change other format properties instead if desired.

Click to expand...