So I've having issues with creating a gant chart in excel. I want the chart to show the original planned dates in red and then if the forecast date is later, it shows this in blue. However as you can see, for row 5, the red should start at 12 Dec and finish at the 8 Dec with no blue, but it seems to end at 17th Jan for some reason. Then row 6 should start at 25 Jan and end at 2nd Feb, and then blue from 10 Feb to the 18 Feb etc.
This is my current conditional formatting settings, and from this I can't work out why its not working: