Font color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to link two worksheets together so that when I change
the font color in a single cell in worksheet 2, it will do the same (change
font color) on worksheet 1. Excel 2003.
 
That would require an event macro. put something like this in your
worksheet code module (right-click the worksheet tab and choose View
Code):

Private Sub Worksheet_Activate()
Const csTarget As String = "A1" 'change to suit
Range(csTarget).Font.ColorIndex = _
Sheets("sheet2").Range(csTarget).Font.ColorIndex
End Sub
 
Back
Top