Conditional Formatting, more than three?

[Swingerhead]

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,

 

[dude]

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

 

[Guest]

hi,
as a built in function, i am afraid you may be stuck.
you might try these sites(maybe) for more help

http://www.contextures.com/xlCondFormat01.html
http://www.mvps.org/dmcritchie/excel/condfmt.html

if not then you may be stuck with writing code using
select case maybe.