Want to have Dynamic Conditional Formatting?

Want to have Dynamic Conditional Formatting?

I have a situation in which I need to use Multiple Colours and therefore it cannot be done in the regular 3 conditions or not in 2007 where you get 7 condtions for Conditional Formatting...
(I have Office 2003 Installed)

I have several activities which are denoted by different colours...
These activities are certainly more than 7 so this cannot be achieved by the regular ways...

What I want is to get the same Colour for the entire strip where the condition matches for that Activity...

For Ex:
In cell B2 = Data Entry Fill Colur Yellow then
wherever the condition matches it should get coloured Yellow..in the Row 2.
If I change the Colour to Red then the colour should change to Red in the matching cells...

Basically Matching Cell Colour = Fill Colour of Column B and Row 2..

I do not know how to explain this more, hope I have been able to put it correctly...

Excel 2007 has unlimited conditions in CF.

'-----------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'-----------------------------------------------------------------
Const WS_RANGE As String = "H1:H10"    '<=== change to suit

    On Error GoTo ws_exit:
    Application.EnableEvents = False
    If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
        With Target
            Select Case .Value
                Case 1: .Entirerow.Interior.ColorIndex = 3    'red
                Case 2: .Entirerow.Interior.ColorIndex = 6    'yellow
                Case 3: .Entirerow.Interior.ColorIndex = 5    'blue
                Case 4: .Entirerow.Interior.ColorIndex = 10   'green
            End Select
        End With
    End If

ws_exit:
    Application.EnableEvents = True
End Sub

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.

Bob Can u please attach a Worksheet?

Im not versed with VBA at all and am not able to understand Head or Tail...as to what the code is going to do?

Excel 2007 has unlimited conditions in CF. Thanks for this info however I have 2003 anyways...

What I want is to Fill colour in Column b starting from Cell B2 onwards till lets say B15 which has all different activities in each cell..

Every Activity would have a Different COLOUR ..
So the entire Row owuld need to get coloured with the same Colour selected in cell B2,B3 AUTOMATICALLY wherever it matches its condition...

Please attach A Sheet with the same code added as I was not able to follow anything...

Im attaching the File for your reference...

Bob I have attached my actual Worksheet?
The earlier one was for your reference...in which I had added the VBA code..

Dear Forum,
Every Activity would have a Different COLOUR ..
What I want is whichever Colour I select in the Column B under Project Activity for different acitivities should get copied to the entire Row till the Column V
i.e. Last Date Entry for the Project Book (2-Apr-09)
As you can see the Yellow strip is appearing in only those cells which are falling in the Range.
I need help on Conditional Formatting code for filling the respective cells falling in the Start Date and End Date.
The Matching cells should have the same colour as the one for the same Activity in the Column B...

Have explained everthing in the Call-outs...in intricate details...

You have effectively posted a blank worksheet.

So you don't want conditional formatting at all, just a bunch of differently coloured rows?