Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells on Different Worksheets
I'm making a workbook that has 1 Worksheet which summarizes the data
contained on the other 10 worksheets. I'm using formulas to reference the value on the 10 worksheets on the summary page. (ex. "=Sheet2!B2) to show the value in "Cell B2 on Sheet2" in the appropriate cell on the Summary page. I would really like to also include the background colour of Sheet2-Cell B2 on the summary page, as each of the 10 worksheets are colour coded to represent their category. Is there any way for the reference to automatically bring more than just the value of the referenced cell, and also include the formatting (or the background colour)? Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells on Different Worksheets
A formula can only return a value to a cell, not a format, so I'm
afraid the answer is no. You would need a macro to do this. Hope this helps. Pete On Nov 6, 6:05 am, KristinD wrote: I'm making a workbook that has 1 Worksheet which summarizes the data contained on the other 10 worksheets. I'm using formulas to reference the value on the 10 worksheets on the summary page. (ex. "=Sheet2!B2) to show the value in "Cell B2 on Sheet2" in the appropriate cell on the Summary page. I would really like to also include the background colour of Sheet2-Cell B2 on the summary page, as each of the 10 worksheets are colour coded to represent their category. Is there any way for the reference to automatically bring more than just the value of the referenced cell, and also include the formatting (or the background colour)? Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells on Different Worksheets
Hi KristinD
You can use this maybe :Edit | Paste Picture Link See the example on this page how http://www.rondebruin.nl/print.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "KristinD" wrote in message ... I'm making a workbook that has 1 Worksheet which summarizes the data contained on the other 10 worksheets. I'm using formulas to reference the value on the 10 worksheets on the summary page. (ex. "=Sheet2!B2) to show the value in "Cell B2 on Sheet2" in the appropriate cell on the Summary page. I would really like to also include the background colour of Sheet2-Cell B2 on the summary page, as each of the 10 worksheets are colour coded to represent their category. Is there any way for the reference to automatically bring more than just the value of the referenced cell, and also include the formatting (or the background colour)? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing worksheets | Excel Discussion (Misc queries) | |||
Referencing worksheets | Excel Discussion (Misc queries) | |||
Referencing Worksheets | Excel Discussion (Misc queries) | |||
Referencing cells in different worksheets | Excel Worksheet Functions | |||
Referencing worksheets | Excel Worksheet Functions |