Despite looking at a similar topic I have not been able to solve this yet. I want to create a vertical line that automatically updates with week number in my sheet (not chart). See picture.
Somehow, I can not solve it with conditional formatting. Can you help me with what/how to make the formatting or (preferably) using a macro.
I have illustrated how I want it to look using an inserted figure.
Hope someone can help.
The formatting takes me to here:
.
However, the layout/visual is not super good as it over writes what is already in there.
