VBA Click Color Follow up

[Inquiring_Minds]

Everyone was already helpful about the click colors, but I was wondering if there was a way that I could only apply the click colors to certain cell ranges ("C2:C4"), ("E2:E4") and ("G2:G4"). I feel pretty dumb not knowing some of this, lol. This is what I currently have.

Sub NoFilling()
Selection.Interior.Color = xlNone
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Target.Interior.Color = vbGreen
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Target.Interior.Color = vbRed
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Interior.ColorIndex = xlNone
End Sub

 

[Fluff]

Duplicate to: VBA Color Changing Cell with multiple clicks

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.