Copying cell colours

A

Atomic

I need know if anyone can help me with how I can make one cell copy the fill
colour of another cell?

i.e

A/01 is turned Red
I also want B/o1 to be Red

A/01 is turned Red
I also want A/05 to be Red

Thank you in advance.
 
J

JE McGimpsey

One way:

Put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Range("B1,A5").Interior.ColorIndex = _
Range("A1").Interior.ColorIndex
End Sub

Note that the change won't take effect until you change the selected
cell.

If you're not familiar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top