Hello everyone,
I am using the Simple Gantt chart template from Vertex42 for work. My boss is requesting I add a new column in "G" for a "completed date". Say the task was completed 1 or 2 days before the predicted end date (F column, that I will rename "due date") this column would reflect that. Now, my question is how do I condition the bars under the calendar to turn green when a value is entered into the new "completed date" column in G. Also, is there a way I could turn the bars red if the current date is past the "due date" (end date, F column)? Thank you everyone in advance!
Bookmarks