Forum Discussion
SOS: Gantt chart formulas and conditional formatting
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)
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)
Do you know how I could do the % complete function ie. show visually that 60% of the task has been completed?
To visualize the % progress, you may add Data Bars and to do so, select the cells in column G --> Conditional Formatting --> New Rule and refer to following image and have the same setup and this will apply the data bars in column G.
- Subodh_Tiwari_sktneer
last question... is there a formula to make public holidays excluded in the same way that weekend are?