Transferring contents and color of cell

[Les]

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

 

[Dave Peterson]

Formulas return values to the cells with the formula. They don't return
formatting.

You could copy and paste special|Formats or have a macro do this for you if you
want--just record a macro when you do it once manually and you'll have your
code.

 

[Les]

Hi Dave,

Yes I understand what you say that formulas return values. I do not want to
consider a macro since I want this to be an automatic method. If that is
the only way to do it then I have no choice but to use conditional
formatting on my summary sheet just like I use on the other 10 sheets.

Thank you very much for trying to help Dave I appreciate it,

Les

 

[Dave Peterson]

Sometimes, you can use macros that look very automatic.

Depending on how the other cells change, you might be able to use one of the
worksheet_change events to do the copy|pasting.

You can read more about events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm