Are you using copy - PasteSpecial with only the FORMAT type selected?

the conditional formating is a type of format so the any format of the
original cell will be copied including borders, and background colors.

"Nicole" wrote:

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?