Formula capturing formatting information
 

I have a very simple formula in one sheet in a workbook setting a cell equal
to the value of a cell in another sheet. But when I say "equal" I want the
target cell to capture not only the value, but the font colour and bold/not
bold, etc. Can I do this?

Formula capturing formatting information
 

No, it will only return the value in the cell,
Regards,
Alan.
"Bob Surbiton" wrote in message
...
I have a very simple formula in one sheet in a workbook setting a cell
equal
to the value of a cell in another sheet. But when I say "equal" I want
the
target cell to capture not only the value, but the font colour and
bold/not
bold, etc. Can I do this?

Formula capturing formatting information
 

Has anu body got a workaround for systematically keeping updated a whole load
of cells from one sheet to another, with all their formatting information?

"Alan" wrote:

No, it will only return the value in the cell,
Regards,
Alan.
"Bob Surbiton" wrote in message
...
I have a very simple formula in one sheet in a workbook setting a cell
equal
to the value of a cell in another sheet. But when I say "equal" I want
the
target cell to capture not only the value, but the font colour and
bold/not
bold, etc. Can I do this?

Formula capturing formatting information
 

copy a rangeeditpaste specialrecord a macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Surbiton" wrote in message
...
Has anu body got a workaround for systematically keeping updated a whole
load
of cells from one sheet to another, with all their formatting information?

"Alan" wrote:

No, it will only return the value in the cell,
Regards,
Alan.
"Bob Surbiton" wrote in message
...
I have a very simple formula in one sheet in a workbook setting a cell
equal
to the value of a cell in another sheet. But when I say "equal" I want
the
target cell to capture not only the value, but the font colour and
bold/not
bold, etc. Can I do this?