![]() ![]() ![]() I strongly recommend against using Merged cells anywhere in your worksheet. Note that Project_Start should refer to D3 instead of D3:E3. I also changed the H5 to match Project_Start named range instead of hardcoding the date. Select the whole section and conditional formatting - highlight cells based on their values - format both Font and Fill to same color (look into Custom Color HEX# to pick the same color grade) if value = 1, and = White if value = 0 Add a formula in each cell from column H to the right-most column: =IFERROR(IF(AND(H$5>=$D8,H$5<=$E8),1,0),"")ΔΆ. I only present the suggested solution to Developmental section (row 8 to 15) and Implementation section (row 20 to 26). Am not quite sure how you currently generate your Gantt chart? Did you do it by manually color the cells? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |