Conditional Formating more than 3 items

[Ruth]

I am creating a Gantt chart that has the following columns: Resource, Task, Start Date, Final Date. I am trying to have the "bars" of the date range to change colors depending on the Resource. Any suggestions?

Thanks!

 

[Jack in the UK]

HI --

Your need VBA for that oner i have some 25 conditions in one sheets to colour rows subject to A B C D E etc.. can email tommorow as no email at home, any good

your need to edit the code its easy enough you see peoples name just change ...

HTH
Rdgs
==========
Jack

Chris D if you read this please enmail me and tell me to take my code VBA home and tell me to set up a hotmail account, so i can help a few guys.. cheers mate.

 

[Chris Davison]

Chris D if you read this please enmail me and tell me to take my code VBA home and tell me to set up a hotmail account, so i can help a few guys.. cheers mate.

Jack : yeppers....done !

Ruth, I use a Gannt chart at work, alas, am now at home. However : the gannt chart uses its 3 conditional formats to make the bars depending on >=start date /<=end date / inbetween, if you wanted it to also take into account, say, 5 projects, that would be 15 conditions, a no-no : if however, you used each condition in conjunction with an AND on the first project, you could produce a chart for that project in it's own colour. Repeat this in another chart with an AND for the 2nd project and you get another chart in a different colour.... repeat for all projects. Now you have 5 or 6 or 7 seperate gannt charts : but, if they are all identical, you can snapshot them and pop them ontop of the first so they all show : ie 5 layers all on top of each other, all with different coloured bars. If this sounds useful, pop your email details in your reply and I'll send through an example tommorrow from work. A quick test on green, red and blue bars works fine

Mr Excel : is there any scope for being able to post images here or maybe a small server area where we can lodge examples temporarily ? I'd even pay a small fee for this facility

Anyhow, hope this helps
Chris

This message was edited by Chris Davison on 2002-02-21 14:08

 

[Jack in the UK]

Chris

Good man i really must get email at home this is getting silly..

Cheers Mate

Rdgs
========
Jack 2 am knock of i guess?