This 4th part of the How to Make a Gantt Chart series shows how to change the color of the bars of the chart by selecting a color from a new Color column or based on a name listed in the Lead column. It also shows how to highlight the tasks that are overdue. This is an advanced Excel tutorial, designed to help project management professionals and students learn more about Excel. To download a template, see the links below.
This video picks up where Part 3 left off, so watch the other videos first:
Part 1: [ Ссылка ]
Part 2: [ Ссылка ]
Part 3: [ Ссылка ]
CONTENTS
0:00 Introduction
0:30 Insert a new Color column
0:46 Make a new relative named range called "task_color"
1:20 Show method for modifying the CF rule with task_color="P"
1:35 Set up a "Stop If True" conditional formatting rule
2:33 Add all of the new color rules, with some color tips along the way
5:02 Set up a drop-down list in the Color column
5:17 Color Code based on the name in the Lead column
6:24 Highlight overdue tasks using a formula or a new CF rule
7:48 Add a checkbox form control to turn the Show Overdue option on/off
8:12 Show overdue tasks by highlighting the End date column
8:50 Warning about Excel splitting CF rules, and how to avoid that
👍 Remember to Subscribe and Turn on Notifications (click on the bell)
VOTE to Make Merging Conditional Formats the Default Behavior:
See the following article (Suggestion #7) [ Ссылка ]
ABOUT THIS VIDEO SERIES
[ Ссылка ]
DOWNLOAD THE FILES
The files for this video series are available as bonus downloads with the purchase of Gantt Chart Template Pro:
[ Ссылка ]
FOLLOW VERTEX42 HERE:
Twitter: [ Ссылка ]
Pinterest: [ Ссылка ]
Facebook: [ Ссылка ]
Website: [ Ссылка ]
MUSIC: A Good Mood, by Young Rich Pixies, licensed via ArtList
