Results 1 to 2 of 2

GANTT chart highlight complete

This is a discussion on GANTT chart highlight complete within the Excel Questions forums, part of the Question Forums category; I have a gantt chart created in excel using cells as opposed to a graph. task start end % 100 ...

  1. #1
    Board Regular
    Join Date
    Sep 2013
    Posts
    967

    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,503

    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!

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