Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blue Cells | New Users to Excel | |||
What is blue triangle? | Excel Discussion (Misc queries) | |||
Blue screen | New Users to Excel | |||
blue squares | New Users to Excel |