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.