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