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

Thread: GANTT chart highlight complete

  1. #1
    Board Regular
    Join Date
    Sep 2013
    Posts
    1,000
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default GANTT chart highlight complete

    I have a gantt chart created in excel using cells as opposed to a graph.

    task start end %
    100

    The gantt chart works to the right of this table example above.

    Currently the conditional formatting will highlight cells in blue according to the dates. If I change the % to 100 (meaning complete) I need the bars currently blue to change to green.

    Is this possible.

  2. #2
    Board Regular
    Join Date
    Sep 2012
    Location
    Melbourne Australia
    Posts
    1,534
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: GANTT chart highlight complete

    yes, add a condition that says if the % value is 100 the format is green, and select the stop if condition is true toggle.
    That should work.
    Write a man a macro he is happy for the day....teach a man to write a macro, he'll be happy forever!

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
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com