Gantt Charts done with Conditional Formatting

**nielsoneo** · 03-15-2012, 05:06 PM

I put together a Gantt chart with conditional formatting, it seems to be working great. Until I change the 'Est. End Date' to "complete". Is there a way to format the chart (cells next to the est. end date) to be blank if the formula doesn't match...or is there a formula I can add that would be something like
"if cell $G3 = completed, then format "no color"?

I have attached a copy of the spreadsheet.

**Pete_UK** · 03-15-2012, 07:22 PM

This is the formula you currently have controlling the conditional formatting on row 3:

=AND(H$2>=$E3,H$2<=$G3)=TRUE

You don't need the =TRUE at the end, and you can edit the formula to read this:

=AND(H$2>=$E3,H$2<=$G3,$G3<>"Completed")

Hope this helps.

Pete