format goes blue
 

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?

format goes blue
 

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?

format goes blue
 

I have tried this and various other ways! Every time the entire background
turns light blue and the RAG changes to yellow... very strange.

"Joel" wrote:

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?

format goes blue
 

You probably have to copy the formating from another destination sheet cell
to get the format back to the proper settings. I usually add the paint brush
to my tool bars (in mine it is in the standard toolbar) and use the paint
brush to copy the formating from another cell.

"Nicole" wrote:

I have tried this and various other ways! Every time the entire background
turns light blue and the RAG changes to yellow... very strange.

"Joel" wrote:

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?