Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell without its own format?
Good afternoon --
I'd like to know if a cell can be designated to pick up the formatting from the cell from which it's receiving it's data. I'm designing a workbook to be used by a wide variety of people, and have built 40-50 different indicators that they might want to use. I'd like them to be able to put those indicators together in whatever order and graphs they want. My basic approach is to allow them to select the name of the index, and then use a VLOOKUP function to get the associated data into the right cells in the table. Problem -- formatting! Some of the indices are %, some $, some are integer ratios, others have decimal points of significance. Can I set up the "target" cell to use the formatting from the "source" cell where it gets its info? BTW -- You guys, collectively, are the best! Thanks for past help and into the future. TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell without its own format?
Formulas return values but cannot return the formatting from the source cells.
Gord Dibben MS Excel MVP On Thu, 24 Jan 2008 14:28:15 -0800, pdberger wrote: Good afternoon -- I'd like to know if a cell can be designated to pick up the formatting from the cell from which it's receiving it's data. I'm designing a workbook to be used by a wide variety of people, and have built 40-50 different indicators that they might want to use. I'd like them to be able to put those indicators together in whatever order and graphs they want. My basic approach is to allow them to select the name of the index, and then use a VLOOKUP function to get the associated data into the right cells in the table. Problem -- formatting! Some of the indices are %, some $, some are integer ratios, others have decimal points of significance. Can I set up the "target" cell to use the formatting from the "source" cell where it gets its info? BTW -- You guys, collectively, are the best! Thanks for past help and into the future. TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell without its own format?
On Jan 24, 10:28 pm, pdberger
wrote: Good afternoon -- I'd like to know if a cell can be designated to pick up the formatting from the cell from which it's receiving it's data. I'm designing a workbook to be used by a wide variety of people, and have built 40-50 different indicators that they might want to use. I'd like them to be able to put those indicators together in whatever order and graphs they want. My basic approach is to allow them to select the name of the index, and then use a VLOOKUP function to get the associated data into the right cells in the table. Problem -- formatting! Some of the indices are %, some $, some are integer ratios, others have decimal points of significance. Can I set up the "target" cell to use the formatting from the "source" cell where it gets its info? BTW -- You guys, collectively, are the best! Thanks for past help and into the future. TIA It could be possible to create a VBA routine which monitors an entire worksheet and searches for new VLOOKUPS entered into it. The routine could then search for the source cell and copy the formatting from that cell into the cell containing the VLOOKUP. I can have a look into it if you like and post my findings here if you like. Regards, Matt Richardson http://teachr.blogspot.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |