you could write some vba code to test the conditions you
are looking for. Something like following may work for you:

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
With ActiveCell
Select Case .Value

Case "david"
With .Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
.Font.ColorIndex = 2

Case "john"

With .Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
.Font.ColorIndex = 2

Case "steve"

With .Interior
.ColorIndex = 5
.Pattern = xlSolid
End With
.Font.ColorIndex = 2
End Select
End With
End Sub

I have only shown three conditions but you should be able
to add more.

Hope helpful

-----Original Message-----
Is there a way to have more than 3 formulas for
conditional formatting? If you have a solution can you
please post in this forum, I dont have access to most
sites from work. :-(

Thanks,
.