| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep cell colour when linking
I'm trying to keep the cell colour from the original worksheet when I link
the data to another worksheet, the colour is added manually and not conditional. Does anyone know how I can do this? Many thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keep cell colour when linking
That is not possible. You could try a picture link (copy cells, then hold
shift and goto Edit - Paste picture link) The cells won't be editable, but they will look exactly like the source data, and will update -- Best Regards, Luke M "Lena" wrote in message ... I'm trying to keep the cell colour from the original worksheet when I link the data to another worksheet, the colour is added manually and not conditional. Does anyone know how I can do this? Many thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keep cell colour when linking
Thank you Luke M, worked fine but unfortunately didn't solve my problem.
"Luke M" wrote: That is not possible. You could try a picture link (copy cells, then hold shift and goto Edit - Paste picture link) The cells won't be editable, but they will look exactly like the source data, and will update -- Best Regards, Luke M "Lena" wrote in message ... I'm trying to keep the cell colour from the original worksheet when I link the data to another worksheet, the colour is added manually and not conditional. Does anyone know how I can do this? Many thanks . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keep cell colour when linking
Linking formulas cannot copy the color.
All formulas can do is return values. Gord Dibben MS Excel MVP On Wed, 3 Mar 2010 09:10:01 -0800, Lena wrote: Thank you Luke M, worked fine but unfortunately didn't solve my problem. "Luke M" wrote: That is not possible. You could try a picture link (copy cells, then hold shift and goto Edit - Paste picture link) The cells won't be editable, but they will look exactly like the source data, and will update -- Best Regards, Luke M "Lena" wrote in message ... I'm trying to keep the cell colour from the original worksheet when I link the data to another worksheet, the colour is added manually and not conditional. Does anyone know how I can do this? Many thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| textBox font colour the same as cell font colour???????? | Excel Discussion (Misc queries) | |||
| How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
| linking colour format between sheets | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| In Excel Auditing linking lines(blue colour) are not shown proper. | Excel Worksheet Functions | |||
Linear Mode
