GANTT chart highlight complete

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,077
    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
  •  

 

 
DMCA.com