Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel 2003 cell link carry with it the source cell format?
I'm using simple links as well as Vlookups to retreive data from another
workbook. However, I need to not only retreive the cell content I need to copy the source cell format, i.e. shading, text coloring, etc. I can't use manual format pasting as the format in the source cell can change at anytime based on other users' input. Is this possible (and how) with standard Excel worksheet functions to do this (i.e. without using something like a macro/VBA)? Any help would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel 2003 cell link carry with it the source cell format?
Is this possible........with standard Excel worksheet functions
No. If the source cells are conditionally formatted then you can apply that same CF to the formula cells. Biff "Tom" wrote in message ... I'm using simple links as well as Vlookups to retreive data from another workbook. However, I need to not only retreive the cell content I need to copy the source cell format, i.e. shading, text coloring, etc. I can't use manual format pasting as the format in the source cell can change at anytime based on other users' input. Is this possible (and how) with standard Excel worksheet functions to do this (i.e. without using something like a macro/VBA)? Any help would be greatly appreciated. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel 2003 cell link carry with it the source cell format?
I was afraid of that....
Thanks Biff for the quick response... its saved me a lot of time trying to figure out how to do it. "Biff" wrote: Is this possible........with standard Excel worksheet functions No. If the source cells are conditionally formatted then you can apply that same CF to the formula cells. Biff "Tom" wrote in message ... I'm using simple links as well as Vlookups to retreive data from another workbook. However, I need to not only retreive the cell content I need to copy the source cell format, i.e. shading, text coloring, etc. I can't use manual format pasting as the format in the source cell can change at anytime based on other users' input. Is this possible (and how) with standard Excel worksheet functions to do this (i.e. without using something like a macro/VBA)? Any help would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell format in Excel 2003 | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) |