Is there an easy way of not only transferring the contents of a cell to
another sheet within a workbook (which I do with an equation) but also the
fill color of the cell. Right now I use an Indirect statement to get this
done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of data
that may be different colors depending on the conditional statements. I
also have one summary sheet which will list all the data from the 10 sheets.
I prefer not to put the conditional statements into my summary page as well
and is why I am hoping there is a way.

Thank you in advance,

Les