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