I have modified a Gantt chart based upon http://www.mlynn.org/2012/05/excel-p...g-spreadsheet/

I would like to add to the conditional formatting so that the Gantt bar is formatted RED if the task's end date (F21-47) has passed based upon the 'Today's Date' field (C49) , and if its % complete (G21-47) is less than %100.

I have tried and tried to modify conditional formatting by adding a rule and using a formula to determine which cells to format. Nothing so far seems to work out right -- probably because of my limited knowledge of the formulas. Can anyone help with the formula that I should input into the 'edit the rule desciption' 'Format values where this formula is true:' ?

I would attach my specific eccel file, but apparently I dont have the correct permissions, so that only reference I have is the orignial file and directions that I used to create my Gantt in the first place.

I hope all this makes sense and that someone out there can help me.

Thanks in advance!