how can I format to show different colour after edit

I

Ismail

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
 
M

Mangesh Yadav

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
 
G

Gary

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