Lesson#87: How to make month wise auto-updating program schedule

Lesson#87: How to make month wise auto-updating program schedule

Previously I have discussed in a post

Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart

It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format.

First I will make the date format above the Gantt chart area by “mmm-yy” from Format Cells>CustomĀ and drag them up to the requirement.

I will add this formula to show the automatic updating Gantt chart bar

=IF(AND(DATE(YEAR($D2),MONTH($D2),1)<=G$1,EOMONTH($E2,0)>=EOMONTH(G$1,0)),”>”,””)

and I will drag it up to the last.

Now I will select the area of the Gantt chart and put this Formatting from Conditional Formatting>Highlight Cells Rules>Text that Contains

I will format the area for “>” this character and I will choose the Fill color and text color the same.

See your month-wise Gantt chart is ready.

Download the sheet.

See also  Short Tips#0069: How to highlight blank cells

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

0 Comments on “Lesson#87: How to make month wise auto-updating program schedule

Leave a Reply

Your email address will not be published. Required fields are marked *

*