format goes blue

  • Thread starter Thread starter Nicole
  • Start date Start date
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?
 
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.
 
I have tried this and various other ways! Every time the entire background
turns light blue and the RAG changes to yellow... very strange.
 
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.
 
Back
Top