Gantt chart that changes based on start date, duration of task and dependency

I am looking to automate the attached excel spreadsheet so that it updates when the following cells are changed:
- Start date
- Task Duration (excluding weekends)
- Dependency

Is this possible to do in excel?

Any input would be much appreciated.

Thank you

Try this formula in F3, then autofill for the rest

=IF(AND(F$2>=$C3,F$2<=WORKDAY($C3,$D3)-1),TRUE,FALSE)

Then you can apply some conditional formatting

Thanks Smally,

That works great for the tasks, but does not change the timeline of task based on a dependency.

Is it possible to do that in excel?

I don't know what you mean sorry. From what you provided the greyed cells did not seem to rely on dependency at all

Hello,

I was hoping that the Gantt would change based on the dependency in column E.

For example: Task 5 can't start until Task 4 is completed; Task 6 can't start until Task 3 is completed.

Is there a way to automate this in excel?

Thanks for any suggestions.

Hi Popopopo,

Thank you for this.

Can you clarify why Task 4 start date changed from the original date, when it does not have a dependency?

Many thanks,
Adam