| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change colour of data when changed
Hello
I have been using the code below in my worksheets to change the colour of updated/edited data. Now it doesn't seem to be working Any ideas why? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub Private Sub Worksheet_Change(ByVal Target As Range) Target.Interior.ColorIndex = 8 End Sub Martin ©¿©¬ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| change data source for many queries at once? | Excel Worksheet Functions | |||
Threaded Mode
