| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatt of cell filled by formula
I have a summary sheet a the begining of a workbook. This sheet picks up the
contents of cells through different each worksheet by a formula eg ='sheetname'!E5. How can I get this to also pick up the formatt of the cell, specficaly the colour of text. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatt of cell filled by formula
Formulas return values. They won't return formatting.
Madhvi wrote: I have a summary sheet a the begining of a workbook. This sheet picks up the contents of cells through different each worksheet by a formula eg ='sheetname'!E5. How can I get this to also pick up the formatt of the cell, specficaly the colour of text. Thank you -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatt of cell filled by formula
If the source cells are colored due to Conditional Formatting you can also
CF the destination cells. Gord Dibben MS Excel MVP On Tue, 13 Jan 2009 07:39:01 -0800, Madhvi wrote: I have a summary sheet a the begining of a workbook. This sheet picks up the contents of cells through different each worksheet by a formula eg ='sheetname'!E5. How can I get this to also pick up the formatt of the cell, specficaly the colour of text. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide a formula result until cell has been filled | Excel Discussion (Misc queries) | |||
| Formatt cell | New Users to Excel | |||
| ?IF function for preventing a cell being filled by formula | Excel Worksheet Functions | |||
| Need formula for last cell filled in on a row | Excel Discussion (Misc queries) | |||
| Can an IF formula result in a color filled cell in Excel? | Excel Worksheet Functions | |||
Linear Mode
