SCHEDULING
Gantt-Style Construction Schedule in Excel
9 min read · Template referenced below
You don't need scheduling software to visualize a project timeline — conditional formatting can turn a plain grid of dates into a bar-chart schedule that updates as you change start and end dates.
1
Lay out your task list.
Column A: Task name. Column B: Start Date. Column C: End Date. Then, starting in column D, list every date of your project timeline across the header row (one column per day or week).
2
Select the date grid.
Highlight the block of cells under your date headers, next to each task row — this is where the bars will appear.
3
Add a conditional formatting rule.
Go to Conditional Formatting → New Rule → "Use a formula," and enter: =AND(D$1>=$B2,D$1<=$C2) (adjust cell references to match your layout). This fills a cell orange whenever that date falls between the task's start and end date.
4
Set the fill color.
Choose a solid fill in the formatting options — this becomes your "bar" segment for each task, automatically shifting if you change a start or end date.
Freeze the first three columns (View → Freeze Panes) so task names stay visible while you scroll across a multi-month timeline.
This method has a real advantage over dedicated scheduling software for small jobs: everyone on the team already has Excel, and there's no learning curve to read or update it.
Back to all tutorials →