Using formula to copy cells

[J]

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.

 

[FSt1]

hi
on the menu bar, click edit>paste 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

 

[Bernard Liengme]

No formula can retrieve the colour of a cell.