The working  time directive states that a man can work no more than 48 hrs in any
rolling 17 week period.
So that equates to 816 hrs for 17 week after which i want the cell which
contains the mans name to turn red.

Week 1 total  hours are in cell E4
Week 2 total hours are in cell E5

and so on for the rest of the year.

So i need one subroutine that check the total hours E4 to E20 (17 weeks) and if
it is more than 816 then turn E2 cell colour Red.

I can then adapt the code to include other ranges ie E5 to E21,E6 to E22 ect.

I have done it woth conditional formatting and calculating the 17 week to a
single cell but it would be easier to adapt and edit if it was done with VBA.

I can post you the file if that will help.