Gantt chart in excel (Formatting from dates)

I am making a schedule for a General Contractor's office. This will go into a Excel file with many sheets that are linked together.

I basically want to create the bars of a Gantt chart in Excel (perhaps using conditional formatting?) I would do this by entering a start date and an end date in the same row. This I want to link to cells in the same row which are underneath a calendar of dates (workdays only). I want the dates the user enters to create formatting (a change in the background color) of the cells underneath dates. This would be for the start and end date as well as the dates in between.

I really want this to be possible. Any help would be much appreciated. I have attached a Jpeg of the what the set-up looks like. Thank you!

Forum Guru JBeaucaire,

The file is attached here.

Thank you in advance!

Thank you! This is great BUT is it possible to do it without Saturday and Sunday? I only want to use workdays because it helps people in the office to see blocks of time visually.

Thanks again.

No the original file was only workdays. Also, the start day, end day, and number of days a project takes will be linked as shown in this attached file.


Can conditional formatting still work?