Can i tell the cell to equal the pattern in another cell?

[Guest]

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.

 

[Guest]

I forgot to mention the information in the cell is different, it's just the
colour i want to replicate.

 

[Dave Peterson]

Not using formulas--formulas return values to the cells.

But you could use a macro:

Option Explicit
Sub testme()
Worksheets("Sheet1").Range("a1").Interior.ColorIndex _
= Worksheets("sheet2").Range("b99").Interior.ColorIndex
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