fill cell with color from other worksheet

[Guest]

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?

 

[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?

 

[Guest]

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

 

[Guest]

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