Hi guys -

I'm trying to create a gantt in excel and i'm trying to figure out if there is a way that, when I enter a start and end date in their respective columns, it fills the relevant cells in the sheet to correspond.

So, for example in the screenshot, if i were to enter in the first row start date as Jan-6 and end date as Feb-4, the cells from Jan-6 to Feb-4 would autofill with a colour.

i've attached a screenshot of the sheet.

Thanks!
Screen Shot 2014-04-08 at 14.43.57.png