Hi
That is a callender that is not made by me.
What i whant is that callender is made by vba because now there are to many formulars.
And not so much conditional formatating ruels.
and look verry good at the red thik lines on the year 2015 2016 2016


Example when the last red line is between week 51 and 52 off 2016. Then is week 52 the first week of the blok of 4 for 2017 so the red thik line is between 2 and 3
when here are to weeknumbers the same with a blanck colum between ore not only a red line after the secound weekniumber
Look at the file it explane everry thing i whant

Attached Files

Kalendernmbs.xlsx (212.6 KB, 15 views)