No formula can retrieve the colour of a cell.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"J" wrote in message
...
I am trying to copy cells from one sheet to another and I would like to
bring
the color of the cell over as well. It also always brings over a 0 if I
don't have any data in the cell. How can I just bring over the color of
the
cell without the 0?

For example, on sheet 1, I would like to copy cell A1 from sheet 2. All
that is in cell A1 on sheet two is the cell is highlighted red. When I do
=Sheet2!A1, all it does is bring over a 0.

Thanks in advance for your help.