Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conditional Formating more than 3 items

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris

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

    Cheers Mate

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •