Interactive PM Dashboard, calendar conditional format|Dashboards & Charts|Excel Forum|My Online Training Hub

Thanks for sharing the video. 

On the conditional format calendar, I want to make a change. 

Instead of having a single date per cell, I grouped them into ranges. For example: 13th-17th, 20th-24th and so forth. 

Any ideas on how to setup the same conditional format of the video but working with date ranges instead of single dates? Example: if I have a task in progress from the 14th through the 16th, I want green-colored the 13-17 cell. 

I hope you can help