Hi Guys,

I had a problem solved by Moo yesterday-superb.

Can this be achieved in excel

I use week numbers ! eg 1 - 52

If I add a week number in a cell - say A1

If B4 -B56 are week numbers 1 - 52

How do I programme so the appropirate colomn is highlighted - say in grey with black boxes

Also If I then want to add the next number of colomns up from the week number in A1 (eg in the same row)-whats that eg week number 15, no. of weeks to add 10 eg adds week no.s 15+16...+24

and to make it easy to read weeks 15 is formatted as are the weeks to the end of the period (eg here 10 )