| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linked workbooks - how to move color as well as data?
We've got two excel workbooks. Workbook A is the master. Workbook B
has cells that point to cells in workbook A. So, when data changes in A, the values change in B. So far so good. Depending on the data in workbook A, the cells in that workbook may change color. Workbook B gets the data, but not the color of the cell containing the data. Is there any modification to the link that would also pull over the cell color? If not, is there an event that's fired when the data (from a link) changes? it doesn't seem to fire the sheet changed event... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linked workbooks - how to move color as well as data?
The short answer is no can do... Functions return values but not formats.
While you could do some macros they are going to be sub-optimal at best. -- HTH... Jim Thomlinson "Newbie" wrote: We've got two excel workbooks. Workbook A is the master. Workbook B has cells that point to cells in workbook A. So, when data changes in A, the values change in B. So far so good. Depending on the data in workbook A, the cells in that workbook may change color. Workbook B gets the data, but not the color of the cell containing the data. Is there any modification to the link that would also pull over the cell color? If not, is there an event that's fired when the data (from a link) changes? it doesn't seem to fire the sheet changed event... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linked workbooks - how to move color as well as data?
Try to copy the format of the cell in A to the cell in B. If the color
change is based on conditional formating that should do the trick. Tom "Newbie" wrote: We've got two excel workbooks. Workbook A is the master. Workbook B has cells that point to cells in workbook A. So, when data changes in A, the values change in B. So far so good. Depending on the data in workbook A, the cells in that workbook may change color. Workbook B gets the data, but not the color of the cell containing the data. Is there any modification to the link that would also pull over the cell color? If not, is there an event that's fired when the data (from a link) changes? it doesn't seem to fire the sheet changed event... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| How can I move multiple linked workbooks between computers | Excel Discussion (Misc queries) | |||
| How do you move names and data between large Excel 2003 workbooks? | Excel Worksheet Functions | |||
| Preserving data integrity in linked workbooks | Excel Discussion (Misc queries) | |||
| Controlling Linked Data to Workbooks | Excel Worksheet Functions | |||
Linear Mode
