| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
retaining formats when referring to cells
I have conditional formats in cells in worksheet A. When I refer to those
cells from WorksheetB, I want to reflect the formats they have in Worksheet A, in WorksheetB Any thoughts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retaining formats when referring to cells
While you can't link formats, you can take the cells in A, copy them, and
paste/special/formats into B -- Gary''s Student - gsnu200739 "Michaeld" wrote: I have conditional formats in cells in worksheet A. When I refer to those cells from WorksheetB, I want to reflect the formats they have in Worksheet A, in WorksheetB Any thoughts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retaining formats when referring to cells
Thanks very much for that, however I am using = rather than paste
e.g a1: Michael ( in italitcs) b1: =a1 ( doesn't bring over the format) and copy/ paste isnt appropriate Would appreciate any other ideas Cheers "Gary''s Student" wrote: While you can't link formats, you can take the cells in A, copy them, and paste/special/formats into B -- Gary''s Student - gsnu200739 "Michaeld" wrote: I have conditional formats in cells in worksheet A. When I refer to those cells from WorksheetB, I want to reflect the formats they have in Worksheet A, in WorksheetB Any thoughts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retaining formats when referring to cells
I am sorry. In Excel, the link only brings over the value, not the format.
As far as I know, the only option is to copy the formats over by hand ( or VBA). -- Gary''s Student - gsnu200739 "Michaeld" wrote: Thanks very much for that, however I am using = rather than paste e.g a1: Michael ( in italitcs) b1: =a1 ( doesn't bring over the format) and copy/ paste isnt appropriate Would appreciate any other ideas Cheers "Gary''s Student" wrote: While you can't link formats, you can take the cells in A, copy them, and paste/special/formats into B -- Gary''s Student - gsnu200739 "Michaeld" wrote: I have conditional formats in cells in worksheet A. When I refer to those cells from WorksheetB, I want to reflect the formats they have in Worksheet A, in WorksheetB Any thoughts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retaining formats when referring to cells
Really do appreciate your feedback
Good weekend Cheers "Gary''s Student" wrote: I am sorry. In Excel, the link only brings over the value, not the format. As far as I know, the only option is to copy the formats over by hand ( or VBA). -- Gary''s Student - gsnu200739 "Michaeld" wrote: Thanks very much for that, however I am using = rather than paste e.g a1: Michael ( in italitcs) b1: =a1 ( doesn't bring over the format) and copy/ paste isnt appropriate Would appreciate any other ideas Cheers "Gary''s Student" wrote: While you can't link formats, you can take the cells in A, copy them, and paste/special/formats into B -- Gary''s Student - gsnu200739 "Michaeld" wrote: I have conditional formats in cells in worksheet A. When I refer to those cells from WorksheetB, I want to reflect the formats they have in Worksheet A, in WorksheetB Any thoughts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort a list with cells referring to others cells | Excel Discussion (Misc queries) | |||
| Retaining formats | Excel Discussion (Misc queries) | |||
| retaining functions or formulas in cells | Excel Worksheet Functions | |||
| retaining data after source cells move | Excel Discussion (Misc queries) | |||
| referring to other cells with formulas | Excel Worksheet Functions | |||
Linear Mode
