Font color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ump4u - 28 Apr 2007 14:22 GMT

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.

Signature

Thanks,
Ump4u

Reply to this Message

JE McGimpsey - 28 Apr 2007 14:45 GMT

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

> 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.

Reply to this Message