Dear,

I just download a free template for project management, it contains gantt chart inside.
I don't know how to make the cell change color without using formula and VBA. Anyone can guide me?

Thanks,
Victor

Howdy. Take a look at Jon peltier's site (http://peltiertech.com/Excel/Charts/GanttChart.html) for explanations.

Thanks for your help~

I have googled few days about Gantt Chart, and I know how to make a Gantt Chart by using Excel > Conditional Formatting right now~~

It is useful~~