Conditional Formatting with Formula Not Working for One Row But All Others Work

[dmarchand1]

Hello - I am using Excel to create a simple Gantt chart for projects. Below is a snapshot of the conditional formatting rule/formula, and another snapshot of the the gantt chart sheet being produced by the formatting. For some reason, one of the rows (Row 41) will not format (fill with color) even though it is in the range (I have highlighted in yellow below). I have tried deleting the row and putting it back and it is still not working. Any thoughts suggestions?

 

[6StringJazzer]

Glad to help! Conditional formatting and date arithmetic are two areas of interest for me, so it's really interesting when they both happen at once.