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.

hi
on the menu bar, click editpaste special....
in the pastespecial dialog box. click formats then click ok.
this will just paste the formats of the copied cell without the data.

Regards
FSt1
"J" wrote:

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.

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.