Using Excel 2007, which I know works better with cell colours, is it possible to copy the cell colour/formatting along with a cell value?

My partner has a spreadsheet with the same headers on two different sheets. The header on the second sheet is poduced with a =sheetname(cell ref) function currently but can this be developed so that the selected cell fill colour is transferred too?