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?

In a word - no.

A formula can not return a format, just a value.

Pete

On Dec 16, 5:39*pm, Dragon2 wrote:
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?

--
Dragon2

are the cell vales being returned unique text
unquie numbers are the a product of an equation
ie. 2*2 =4
The real question is how random are the return and
how many posible returns can come up



"Dragon2" wrote:


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?




--
Dragon2

No it is a text heading that is being transferred so conditional formatting is not an option.