(Macro?) to add text at a certain point

Hi there,
This forum really helped my project work!
The coloured bars in my excel sheet are now made with conditioned formatting

Now I'd like to add something:

At the end of some finished tasks, I'd like to put a text clarification. Which text is stated in column D (I'll hide this part later)
As this is not conditional formatting I don't know how to tell Excel to do so. ¨

Attached I have the excel how I'd like it to look but without the needed function /macro/condition or whatever else is needed to solve this.

How do you tell if a task has finished? There is nothing to indicate actual progress or completion of a task. Do you just assume it's finished if the end date has passed? In your example, the two "completed" tasks are in the future.

yes this is the idea, I insert the end date and then the text appears right next to this date in the calendar

You could have a formula like this in L5:

=IF(L$2=EOMONTH($B$5,0)+1,$D5,"")

but as you wouldn't know in advance which cell that needs to appear in, you would need to copy the formula to other cells, both to the right and the left. All the other cells would thus contain a formula returning a blank, so the text that is displayed in cell L5 is then truncated and only shows the first 1 or 2 characters, so I'm not really sure it is worth it.

Hope this helps.

Pete

Hi Pete, thank you very much!

This was actually much easier than expected.
Is there any way to prevent the cells from returning blank, so that more than the first characters are visible?

Have a nice day

Linda

Well, no, not really, The other cells are not actually empty, as they have a formula in them, and that was the point I was making - because those other cells are not empty, the text that appears in L5 cannot run into them, so you will only see a very limited part of the text.

Pete

Here is a macro version that will insert the text as it is added in column D.

Thank you very much. My prior experience with macros is very limited: When I open the Macro section it is empty in this document. What am I doing wrong? (I already activated the Macros in the Trust Center)