Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel - formula to copy the cell contents and colour. Possible?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel - formula to copy the cell contents and colour. Possible?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel - formula to copy the cell contents and colour. Possible
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel - formula to copy the cell contents and colour. Possible
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 "Jason" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula into the subsequent cells, not contents | Excel Discussion (Misc queries) | |||
Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
copy cell value not contents | Excel Discussion (Misc queries) | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
how do I copy the contents of a cell from one workbook to another | Excel Worksheet Functions |