Want to have Dynamic Conditional Formatting?

[e4excel]

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

[Bob Phillips]

Excel 2007 has unlimited conditions in CF.

Please Login or Register  to view this content.

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.

[e4excel]

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

[e4excel]

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

[Bob Phillips]

You have effectively posted a blank worksheet.

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

[e4excel]

You have effectively posted a blank worksheet.

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

Bob,
I attached two files :
1. First file BOb.xls where I had put your code but could not understand anything because of not knowing VBA.

2.My actual File where I have explained in details my requirement..

I think I am making a mistake in displayimh the Colours in each Row , can someone help me with the Code for the same and also correct me Im getting very confused now...

Trying all osrts of AND & OR , Combination CONDITIONS to no avail.

[e4excel]

Just confused..
This is more tougher than it looks..

Have attached the same Sheet with some Trial and Error Formulas..
Have added an additional Sheet the name being "TRIAL" with the requirement..

Please someone help me on this...

[e4excel]

Dear Forum,

In my Normal Scenario, I have to select every Row starting from Column I till the Last Filled Column with the same colour as in the Column B for its respective Activity.
It becomes tedious when there are lot of Activities and Different Colours.
I want someone to help me with Some VBA coding wherein, whatever colour is selected for the Activity in the Column B it gets instantly copied to the Entire Row from Column I till Column AI, so I would not need to explicitly conditionally format each row with a different Colour..
If that is achieved then hopefully the same Conditional Formatting to only colour the cells which are falling in the Range can be achieved by Formula. [ I3=TRUE ]
The Formula to Display TRUE for the Conditional Formatting to act is
[=IF(COLUMN()-8<=WEEKNUM(PrjEnd),OR(SUM((COUNTIF(Data!B$2:B$8,$c3))>0,AND(I$2>=$C3,I$2<=$F3)
,SUM(COUNTIF(Data!B$2:B$8,$F3))>0),"") ]

[e4excel]

Can someone please help me on the same by Integrating VBA with formulas..
Please go thru the file attached in the earlier post

[e4excel]

Bump no response...

Can someone help me on the same..

[e4excel]

Actually want someone to be able to copy the colour selected in Column B for every Activity and paste the same colour in the Row form Column I to Column AI...

This should happen instantenously...

Please find the attachment explaining the requirement in details.