| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Texts from on sheet to another while maintaining formattin
I am trying to link values from a master list to seperate sheets, so that I
only have to edit the master list and all of my other sheets change accrodingl. I can do this but the only problem I am currently having is I can't get it to recognize the formatting changes such as strike through or font color changes. Is there anyway that I can get this to happen so I don't have to edit all sheets? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Texts from on sheet to another while maintaining formattin
Nope... You can link values but you can not link formats.
-- HTH... Jim Thomlinson "merritaf" wrote: I am trying to link values from a master list to seperate sheets, so that I only have to edit the master list and all of my other sheets change accrodingl. I can do this but the only problem I am currently having is I can't get it to recognize the formatting changes such as strike through or font color changes. Is there anyway that I can get this to happen so I don't have to edit all sheets? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Texts from on sheet to another while maintaining forma
Jim....thanks for the answer.....even if it wasn't what I wanted to hear.
"Jim Thomlinson" wrote: Nope... You can link values but you can not link formats. -- HTH... Jim Thomlinson "merritaf" wrote: I am trying to link values from a master list to seperate sheets, so that I only have to edit the master list and all of my other sheets change accrodingl. I can do this but the only problem I am currently having is I can't get it to recognize the formatting changes such as strike through or font color changes. Is there anyway that I can get this to happen so I don't have to edit all sheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT trouble with number formattin | Excel Worksheet Functions | |||
| Columns and Conditional Formattin | Excel Worksheet Functions | |||
| Linking cell A in sheet 1 with several cells in sheet 2 | Excel Worksheet Functions | |||
| IS THERE A FAST WAY TO CHANGE THE ORDERS OF CONDITIONAL FORMATTIN. | Excel Discussion (Misc queries) | |||
| Text Box formattin | Excel Discussion (Misc queries) | |||
Hybrid Mode
