Help Adding Labels to Excel Gantt

New Contributor

Losing my mind---if there any way to add labels to the conditionally formatted areas for the from the task column without using vba?


I added dashes with an additional IF statement


 =IF(AND(task_end>=BA$5,task_start<BA$5+1), "---", " ")


text copying the task column would be ideal except when i copy, it copies in each cell from the start of the conditional formatting.






3 Replies


Assuming that the task column is column B, you could change the formula to


=IF(AND(task_end>=BA$5,task_start<BA$5+1), $B7, "")

appreciate the quick response. unfortunately, that formula ends up copying the contents of B7 over and over.


What do you want to do instead?