Thank you all for your rapid responses!

They all work, I think i'll use conditional formatting as opposed to VBA though, but now I know how to do it in VBA aswell so I thank you none the less!

You're all so helpful!

Adam