Gantt Chart Conditional formatting

Morning all,

Wondering if anyone could help me with this conditional formatting that i'm having a problem with. I downloaded a pre-made gantt chart from Chandoo - which is absolutely perfect for what i'm needing.

The only problem i have is that i need to be able to see the planned and actual overlapping.. It works when you change the cell from "Planned" to "Actual" but i'd need to see one on top of the other. (Planned being light blue and Actual being Blue)

Any help on this would be great.

Thanks,

gantt.xlsx

Would it be easier to, instead of using "Duration" use another week number?

Thanks