Mutiple Conditional Formatting (more than 4)

[Phillip Vong]

Is there a way to have more than the 4 conditional formatting? I have a
sheet that I want 12 conditional formatting. All looking in colum A and
highlighting each one with a different color.

 

[Ron de Bruin]

Hi Phillip

You need VBA to do this

Here is a example that use the Change event of the worksheet
Right click on a sheet tab and choose view code.
Paste the event in there and press Alt-Q to go back to Excel.

This example will only work in column A

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Dim Number
Number = Target.Value
Select Case Number
Case 1 To 5
Target.Interior.ColorIndex = 3
Case 6, 7, 8
Target.Interior.ColorIndex = 5
Case 9 To 10
Target.Interior.ColorIndex = 8
Case Else
Target.Interior.ColorIndex = 10
End Select
End If
End Sub


Frank Kabel and Bob Phillips are working on a Great Add-in with
30 options.

 

[Phillip Vong]

Thanks for writing back. I'm sorry, but I'm very new at this and I don't
know anything about VB. I did as you said, but what next? When I went to
conditional formatting, I still only see 4. Was I suppose to change
something in your codes? Please help!

Does Frank Kabel or Bob Phillips have an email signup that will notify us
when they have this add on completed?

Phil

 

[Guest]

Philip, Ron is saying that you can't have more than 4 conditional formats in
a cell. It drives me nuts too.

Ron is saying that as an alternative you can use VBA to create an equivalent
to conditional formatting.

His approach may work for you, but there is certainly a lot of effort to get
it to do what you want.

I can only suggest that you either learn VBA or decide on another way to
display your business requirements.

James.

 

[Phillip Vong]

Gotcha. Thanks! Unfortunately, I do not know VB so I guess I'm screwed.
That sucks.