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

M

Mark

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

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

Mark said:
I have 2 worksheets in my workbook. On worksheet "A" i have a number in
Click to expand...
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?
 
D

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
[email protected]
Mark said:
I have 2 worksheets in my workbook. On worksheet "A" i have a number in
Click to expand...
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?
 
M

Mark Graesser

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
[email protected]

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