how can I format to show different colour after edit
 

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

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

how can I format to show different colour after edit
 

Is there a way to put htis into a macro so I can enter this into the sheet
automatically each time I am emailed a new version of the workbook?

Thanks.


"Mangesh Yadav" wrote:

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