fill cell with color from other worksheet

[Crakel]

I created a second worksheet that pulls data from the 1st worksheet. This
works great, but I was also hoping it could pull the color format that fills
cell in the 1st format in addition to the numbers (data). Is this possible?

By way of example, in cell A1 of the first worksheet the number is 352. In
cell B3 of the second worksheet in the same file, I typed in ='Sheet 1'!A1.
This fills cell B3 in my second worksheet (Sheet 2) with the contents of the
first worksheet (Sheet 1), but the color (filled in blue highight), does not
show in cell B3, only the data 352.

cp

[Dave Peterson]

Formulas can't return this kind of formatting.

Maybe you could use a macro to copy|paste the cell?

Crakel wrote:
>
> I created a second worksheet that pulls data from the 1st worksheet. This
> works great, but I was also hoping it could pull the color format that fills
> cell in the 1st format in addition to the numbers (data). Is this possible?
>
> By way of example, in cell A1 of the first worksheet the number is 352. In
> cell B3 of the second worksheet in the same file, I typed in ='Sheet 1'!A1.
> This fills cell B3 in my second worksheet (Sheet 2) with the contents of the
> first worksheet (Sheet 1), but the color (filled in blue highight), does not
> show in cell B3, only the data 352.
>
> cp

--

Dave Peterson

[John James]

You can manually apply the colour, or copy the formats (edit-paste special formats) which copies all formats including colour, or set up a style with this colour and apply the style. There is no in-built functionality to do what you've asked.

A macro which builds the formula and copies the colour in one process is the alternative. Is this justified by your need?

[Crakel]

A macro is probably the way to go. I know I can manually paste the color, but
was just trying to save a step.

Thanks

"Dave Peterson" wrote:

> Formulas can't return this kind of formatting.
>
> Maybe you could use a macro to copy|paste the cell?
>
> Crakel wrote:
> >
> > I created a second worksheet that pulls data from the 1st worksheet. This
> > works great, but I was also hoping it could pull the color format that fills
> > cell in the 1st format in addition to the numbers (data). Is this possible?
> >
> > By way of example, in cell A1 of the first worksheet the number is 352. In
> > cell B3 of the second worksheet in the same file, I typed in ='Sheet 1'!A1.
> > This fills cell B3 in my second worksheet (Sheet 2) with the contents of the
> > first worksheet (Sheet 1), but the color (filled in blue highight), does not
> > show in cell B3, only the data 352.
> >
> > cp
>
> --
>
> Dave Peterson
>

[Crakel]

Copying the formats is fine, but I was really hoping to link them, so if it
changed on the 1st worksheet it would reflect in the second. If a macro is
the way to go I may look into this, but the effort may surpase the need.

Thanks

"John James" wrote:

>
> You can manually apply the colour, or copy the formats (edit-paste
> special formats) which copies all formats including colour, or set up a
> style with this colour and apply the style. There is no in-built
> functionality to do what you've asked.
>
> A macro which builds the formula and copies the colour in one process
> is the alternative. Is this justified by your need?
>
>
> --
> John James
> ------------------------------------------------------------------------
> John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
> View this thread: http://www.excelforum.com/showthread...hreadid=533976
>
>