Referencing Cells on Different Worksheets

K

KristinD

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top