Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
The group previously helped me with a code that changes the colour of cells when the content is edited/changed and it works well Thank you ================================================== = Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Target As Range) Target.Interior.ColorIndex = 8 End Sub ========== What I would like is to further enhance the code so that it DOESN'T make a colour change to inserted or deleted rows, but still allows the cell colour change when the content is edited/changed Is this possible ? -- Martin ©¿©¬ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
Change colour of cells when content is altered/changed | Excel Discussion (Misc queries) | |||
Change colour of data when changed | Excel Discussion (Misc queries) | |||
changing the colour of cells depending on the content. | Excel Discussion (Misc queries) | |||
How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions |