Help Adding Labels to Excel Gantt

[ppal825]

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.

[#2]

@ppal825 

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, "")

[#3]

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

[#4]

@ppal825 

What do you want to do instead?