| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS
Good to hear.
Thanks for the feedback. Gord On Sat, 12 Apr 2008 10:23:19 GMT, Martin ©¿©¬ @nohere.net wrote: On Fri, 11 Apr 2008 15:24:15 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Cells.Count 1 Then Exit Sub If .Value < "" Then .Interior.ColorIndex = 8 End If End With End Sub Thank you very much Gord This does a great job and saves a lot of extra work removing coloured lines the previous code left behind when inserting & deleting lines It's a great time saver |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
