If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press
'enter' it transfers only the text in the sheet 2 cell not the colour of the
cell. Is there anyway that I can get it to transfer the cell colour as well?