Re: Mutiple Conditional Formatting (more than 4)

From: James R-S (JamesRS_at_discussions.microsoft.com)
Date: 11/05/04 

Date: Thu, 4 Nov 2004 17:06:01 -0800

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" wrote:

> 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
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
> news:%23M7NKOrwEHA.1308@TK2MSFTNGP09.phx.gbl...
> > Hi Phillip
> >
> > You need VBA to do this
> >
> > Here is a example that use the Change event of the work***
> > Right click on a *** 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.
> >
> >
> >
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> > "Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
> > news:OwnDTrqwEHA.2836@TK2MSFTNGP11.phx.gbl...
> >> Is there a way to have more than the 4 conditional formatting? I have a
> >> *** that I want 12 conditional formatting. All looking in colum A and
> >> highlighting each one with a different color.
> >>
> >
> >
>
>
>