Can i tell the cell to equal the pattern in another cell?
Is there any way i can tell a cell to equal the background colour of another
cell? For example on one spreadsheet the cell is pink and i want this colour to map to another cell in a different worksheet. Many thanks. |
Can i tell the cell to equal the pattern in another cell?
I forgot to mention the information in the cell is different, it's just the
colour i want to replicate. "Snowy" wrote: Is there any way i can tell a cell to equal the background colour of another cell? For example on one spreadsheet the cell is pink and i want this colour to map to another cell in a different worksheet. Many thanks. |
Can i tell the cell to equal the pattern in another cell?
Not using formulas--formulas return values to the cells.
But you could use a macro: Option Explicit Sub testme() Worksheets("Sheet1").Range("a1").Interior.ColorInd ex _ = Worksheets("sheet2").Range("b99").Interior.ColorIn dex End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Snowy wrote: Is there any way i can tell a cell to equal the background colour of another cell? For example on one spreadsheet the cell is pink and i want this colour to map to another cell in a different worksheet. Many thanks. -- Dave Peterson |
All times are GMT +1. The time now is 11:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com