copy cell format?
 

I have two worksheets. One I use to insert data, the other to summarize
the data I entered. On the data sheet, I have a few items that are
bold/red.

I'm using ='data'!b2 to copy the cell contents from the data sheet into
the summary sheet, it copies the content, but not the format
(bold/red).
How can I correct this?

JF


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=498038

copy cell format?
 

Formulas can only return values--not formats.

I think copy|paste special|formats either manually or via a macro is the way to
go.

(If you need a macro, record one when you do it manually.)

Ltat42a wrote:

I have two worksheets. One I use to insert data, the other to summarize
the data I entered. On the data sheet, I have a few items that are
bold/red.

I'm using ='data'!b2 to copy the cell contents from the data sheet into
the summary sheet, it copies the content, but not the format
(bold/red).
How can I correct this?

JF

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=498038

--

Dave Peterson