Вот кусок справки из 2007 VBA for Excel
Worksheet.Change Event
Occurs when cells on the worksheet are changed by the user or by an external link.
Syntax
expression.Change(Target)
expression A variable that represents a Worksheet object.
Parameters
Name Required/Optional Data Type Description
Target Required Range The changed range. Can be more than one cell.
Return Value
Nothing
Remarks
This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation.
Example
This example changes the color of changed cells to blue.
Visual Basic for Applications
Private Sub Worksheet_Change(ByVal Target as Range)
Target.Font.ColorIndex = 5
End Sub
Сейчас спешу, завтра, если будет свободное время, напишу макрос.
Но ты всеравно сам попробуй разобраться
: Вниз