SOS: Gantt chart formulas and conditional formatting

Hello excel community, I need you help with conditional formatting and formulas in my gantt chart (see doc below). The issues are four fold: 1. When I insert the duration e.g. 5, it blocks out 6...

Charting

excel

Formulas and Functions

Subodh_Tiwari_sktneer
Oct 16, 2019
Wallace123

Select the range I10:DI17 and make a new rule for conditional formatting using the formula given below...

=AND($C10<>"",$D10<>"",I$7>=$D10,I$7<=WORKDAY($D10,$C10)-1,WEEKDAY(I$7,2)<6)

Also, replace the formula in E10 with the following one and copy it down.

In E10
=IF(OR(C10="",D10=""),"",D10+C10)

Forum Discussion

SOS: Gantt chart formulas and conditional formatting

Resources