thanks for the reply....
I'm trying to get a column with 3 colours in it to reproduce on subsequent
pages. Basically a coloured shift rota, so instead of copy and pasting for 8
pages i can do it on page 1 and forget about it. Can that be done with macros?


"Zone" wrote:

You can't control color with a formula. You can do it with a macro. It
would depend on whether you're talking about one particular cell, a certain
range of cells, or every cell on the worksheet.
James

"Jason" wrote in message
...
does a formula exist so if i colour a cell on page one the contents,
including the colour, will be instantly copied onto page 2