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.

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.

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.