Hi Mickerickson,

Thanks again for this, it's helped me improve my understanding of VBA and I've moved a few notch from being a stark rookie.

Can i ask, is there a way i can tweak this around such that the routine doesn't halt once it colors a row? i.e the routine continues till the last row in the worksheet?

sorry if it sounds like I'm asking for too much