Conditional Formatting, more than three?
 

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,

Conditional Formatting, more than three?
 

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,
.

Conditional Formatting, more than three?
 

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.

-----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,
.