I have done it with conditional formatting and some othe calcs to other cells.
Using a VBA routine will just be cleaner.
The cell i want to highlight has the employees name in it so that if his
overtime goes above 816 for any rolling 17 week period it goes turns red.
So all i need is the code that will look at the range E4:E20 and if the sum of
these exceeds 816 then colour cell E2 Red.
I also need it to turn the E2 orange when it reaches 780 (a kind of pre warning
traffic light thing)
I'm still learning VBA and have done some cool thing with it but i can't get my
head round how to do this.