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.

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.

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