How do I change the colour of cells based on a start and end date?

I am trying to set up a resource labour sheet using excel.

Instead of manually shading the cells myself, it would be great if I could configure excel to do it for me- based on the start date and end date of a given task.

-Please see the attached excel sheet as an example.

Not sure if this can be done, any help would be appreciated!

Thanks,
Luke