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.

 

 

 

 

306090.PNG

3 Replies

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

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

@ppal825 

What do you want to do instead?