Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Range(Cells(Target.Row, 1), Cells(Target.Row, 4)).Interior.ColorIndex = 6
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Range(Cells(Target.Row, 1), Cells(Target.Row, 4)).Interior.ColorIndex = 2
End Sub
That fixes the code you had, but are you saying you want the yellow coloring done automatically without the need to click the mouse in a specific cell? If so, is do-able, just need to know what event you want to trigger the code.
The yellow count is also doable, just need to know if you're going to have multiple tables on one sheet like your "What I do now" sheet, what you want done with the yellow count, and if the yellow count is per table or for the whole sheet.
Bookmarks