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




In article ,
Ump4u wrote:

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.