Oops! Yes, with the conditional formatting, the cell that holds the variable # of weeks (A14) needs to be an absolute reference $A$14 since the cond. formatting routine looks at each cell and needs to compare it to a stationary reference. Sorry!

The formula that handles the sum will work with either A14 or $A$14.

Regarding your rolling list from one year into the next, how is your data set up? If you have an example workbook you could upload I could take a look to see how to get it working for you.

- Moo