Can you transfer cell colour with value

[Dragon2]

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

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

 

[Pete_UK]

In a word - no.

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

Pete

 

[Dylan @ UAFC]

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]

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

;770144']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



:
-

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?