conditional formatting schedule

Brass Contributor


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:





1 Reply


Perhaps you should move the rule for blue up to above the rule for red, so that it has precedence.


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?