Color Only Specific Cells in Active Row...

[photonicman]

If anyone could help I would greatly appreciate it.

I need to have the 2nd, 3rd, and 4th cell highlighted / colored in the active row.

I need the color to be removed upon navigating to a new row.

The Code I have colors the three cells for me, but it doesn't remove the color when navigating to a new row.

I just need a way to have the background color automatically cleared upon leaving each active row, and clear only those 3 cells. I have conditional formats and colors all throughout the spreadsheet so only the colored cells only need to be cleared.


Current Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim RR As Range
Set RR = Target

Cells(RR.Row, 2).Interior.ColorIndex = 36
Cells(RR.Row, 3).Interior.ColorIndex = 36
Cells(RR.Row, 4).Interior.ColorIndex = 36

End Sub