| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bring the cell format along with the cell value from a reference c
I am trying to copy the cell value along with the format from a reference
cell. The cell being referenced has a formula for the value and conditional formating to define the color. A simple reference i.e. ='sheet1'!H3 will only copy the value. How can I copy the formating? i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell to be red too. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Bring the cell format along with the cell value from a reference c
Formulas return values.........not formats.
Must be done through a seperate step by using the Paintbrush icon to also copy the CF Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 13:07:02 -0800, "Lorrie Horgen" <Lorrie wrote: I am trying to copy the cell value along with the format from a reference cell. The cell being referenced has a formula for the value and conditional formating to define the color. A simple reference i.e. ='sheet1'!H3 will only copy the value. How can I copy the formating? i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell to be red too. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Cell reference problem | Excel Worksheet Functions | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Hybrid Mode
