Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change colour of cells when content is altered/changed
Hi
I have a number of worksheets where the cell colour used to change to Blue when an entry was made or edited But it ain't doing it any more -------------------------------------- This is the code 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 ------------------------------------------------- I didn't write the code, more likely someone created it for me Would anyone know why the above code has stopped working and how to fix it please ? -- Martin ©¿©¬ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formate colour of cells in a range of raw | Excel Discussion (Misc queries) | |||
Formate colour of cells | Excel Discussion (Misc queries) | |||
How to change cases from small to capital in all cells? | Setting up and Configuration of Excel | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) |