Sep 09 2022 01:02 PM
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.
Sep 09 2022 01:13 PM
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, "")
Sep 09 2022 01:35 PM
Sep 09 2022 02:00 PM
What do you want to do instead?