I have a worksheet which has conditional formatting on it (RAG status) very
simple. However when I copy and paste it into another excel worksheet the
whole of the background goes blue and loses all the formatting...

any ideas?