Re: Mutiple Conditional Formatting (more than 4)

From: Phillip Vong (phillip_vong*at*yahoo*dot*com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 08:43:16 -0500

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

"James R-S" <JamesRS@discussions.microsoft.com> wrote in message
news:A7D2268F-E276-41D1-87A0-7DDC4C4BC062@microsoft.com...
> 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.
>> >>
>> >
>> >
>>
>>
>>