Prev: dynamic defined name
Next: Index Match Help
From: Lena on 3 Mar 2010 07:58
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
From: Luke M on 3 Mar 2010 09:15
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" <Lena(a)discussions.microsoft.com> wrote in message
news:76CFA66C-46AF-43BF-90B9-97407004EA79(a)microsoft.com...
> 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


From: Lena on 3 Mar 2010 12:10
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" <Lena(a)discussions.microsoft.com> wrote in message
> news:76CFA66C-46AF-43BF-90B9-97407004EA79(a)microsoft.com...
> > 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
>
>
> .
>
From: Gord Dibben on 3 Mar 2010 19:16
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 <Lena(a)discussions.microsoft.com>
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" <Lena(a)discussions.microsoft.com> wrote in message
>> news:76CFA66C-46AF-43BF-90B9-97407004EA79(a)microsoft.com...
>> > 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
>>
>>
>> .
>>

 | 
Pages: 1
Prev: dynamic defined name
Next: Index Match Help