Linking data and formating between two spreadsheets
I'm building a spreadsheet that sums results from a number of other
spreadsheets, my question is how to keep both the data and formatting synchronized. I've tried using a formula in the destination file to reference the source and importing with a query - both handle the data values just fine but do not seem to handle formating, such as font color. What is the best technique? Thanks in advance, Peter |
Linking data and formating between two spreadsheets
You can't reference the format of another cell. Perhaps you could use
conditional formatting to apply formats, based on the cell values. Peter Wells wrote: I'm building a spreadsheet that sums results from a number of other spreadsheets, my question is how to keep both the data and formatting synchronized. I've tried using a formula in the destination file to reference the source and importing with a query - both handle the data values just fine but do not seem to handle formating, such as font color. What is the best technique? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Linking data and formating between two spreadsheets
Peter,
I created multiple files (10 in all) dealing with various aspects of my budget. On my main budget program, I have a sheet that lists information from the other sheets. Although I was able to €ślink€ť a cell to another particular cell from another sheet, I wasnt able to €ślink€ť that cells format. No biggie though, for on the main sheet I changed the format to the €ślinked€ť cell and no problems. Sounds complicated, but was EXTREMELY easy (I only needed to format the cell that I was working on one time). "Peter Wells" wrote: I'm building a spreadsheet that sums results from a number of other spreadsheets, my question is how to keep both the data and formatting synchronized. I've tried using a formula in the destination file to reference the source and importing with a query - both handle the data values just fine but do not seem to handle formating, such as font color. What is the best technique? Thanks in advance, Peter |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com