format goes blue

N

Nicole

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?
 
J

Joel

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.
 
N

Nicole

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

Joel

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.
 
Top