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