excel - formula to copy the cell contents and colour. Possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 24 Aug 2007 15:34 GMT

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

Reply to this Message

Zone - 24 Aug 2007 16:28 GMT

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

> 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

Reply to this Message

Jason - 24 Aug 2007 19:44 GMT

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?

> 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
[quoted text clipped - 3 lines]
> > 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

Reply to this Message

Zone - 24 Aug 2007 22:05 GMT

Jason, since you're copying an entire column to 8 other sheets, it would be
better to run a subroutine by clicking a button instead of automatically
copying all this every time you make a change on the main sheet. Can you
live with that? James

> thanks for the reply....
> I'm trying to get a column with 3 colours in it to reproduce on subsequent
[quoted text clipped - 11 lines]
>> > 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

Reply to this Message