| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Icon Set Information Lost when saved as H | Excel Discussion (Misc queries) | |||
| monthly capturing of information | Excel Worksheet Functions | |||
| Capturing The First Change in a Formula | Excel Worksheet Functions | |||
| Capturing data using a formula | Excel Discussion (Misc queries) | |||
| Formatting information copied and pasted from the WEB to excel | Excel Discussion (Misc queries) | |||
Linear Mode
