enter the following code in the module of the sheet in question. The cells
are colored green after you edit them.

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Cells.Interior.ColorIndex = 4
End Sub


- Mangesh



"Ismail" wrote in message
...
I am using Excel 2003
I want to highlight either change the font colour or cell colour after I
edit a cell in a work sheet