| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format to show 0 value | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| Conditional format if cell=0 then font colour same as background . | Excel Discussion (Misc queries) | |||
| Format Cell Colour | Excel Worksheet Functions | |||
Hybrid Mode
