A cell copied onto one worksheet from another worksheet does display same formatting.

[Guest]

I have 2 worksheets in my workbook. On worksheet "A" i have a number in red font with black background in cell B1. On worksheet "B" the contents of cell A1 is =A!B1. This copies the value located in cell B1 of worksheet "A" but not the color formatting. How can that get copied as well?

 

[Harald Staff]

Hi

A formula has one single job: to return a value into its own cell. No
formats, no copying, no dancing, no fun, only that.

--
HTH. Best wishes Harald
Followup to newsgroup only please

I have 2 worksheets in my workbook. On worksheet "A" i have a number in

red font with black background in cell B1. On worksheet "B" the contents of
cell A1 is =A!B1. This copies the value located in cell B1 of worksheet "A"
but not the color formatting. How can that get copied as well?

 

[Don Guillett]

A formula can't do that. But you could use a worksheet_change event to copy
the format also.

if target.address="$A$3" then
target.copy _
sheets("sheetb").range("a4"). paste pastespecial:=all
end if

--
Don Guillett
SalesAid Software
(e-mail address removed)

I have 2 worksheets in my workbook. On worksheet "A" i have a number in

red font with black background in cell B1. On worksheet "B" the contents of
cell A1 is =A!B1. This copies the value located in cell B1 of worksheet "A"
but not the color formatting. How can that get copied as well?

 

[Guest]

Mark
Are you changing the format in sheet A and want the format in B to change also? If so, waht are the reasons you change the format? You might be able to use Conditional Formatting on both sheets

Good Luck
Mark Graesse
(e-mail address removed)

----- Mark wrote: ----

I have 2 worksheets in my workbook. On worksheet "A" i have a number in red font with black background in cell B1. On worksheet "B" the contents of cell A1 is =A!B1. This copies the value located in cell B1 of worksheet "A" but not the color formatting. How can that get copied as well?