Conditional formatting with weeknumbers
For our planningscheme I use: a startdate, duration and endweek (Y-axis), and the weeks of the year (X-axis). If the weeknumber in the X-axis is within the start and endweek it needs te be coulored. This far I am able to do this. The problem starts when the planning goes to the next year. From that point the weeknumbers start over from 1. But my created formula only understands the colouring until week 52. How do I need to make the conditional formatting to show all the right colours according to our planning?