Highlight active row Except cells that are currently highlighted

[Falko26]

Hey Team,
I have this code that highlights the entire row of the active cell. But I don't want it to mess with the cells I already have highlighted in that row.

Is there a way to modify this to only highlight cells that are not currently highlighted?? This way my highlighted cells are not affected?

Thanks,

Dim i As Long

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If i > 3 Then
    
Rows(i).EntireRow.Interior.ColorIndex = 0
End If
i = Target.Row
If i > 3 Then
Rows(i).EntireRow.Interior.Color = RGB(255, 242, 204)
End If
End Sub

 

[DanteAmor]

Try a conditional format.

Step a) Change your code to this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Row > 3 Then
    Application.ScreenUpdating = True
  End If
End Sub

Step b). Put the following conditional formatting on your sheet:
1. Select all cells .
2. Create a conditional formatting rule, and select the Formula option 3.
3. Enter a formula:

=ROW()=CELL("row")

4. Select Format to put the fill color in the cells

 

[Falko26]

Try a conditional format.

Step a) Change your code to this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Row > 3 Then
    Application.ScreenUpdating = True
  End If
End Sub

Step b). Put the following conditional formatting on your sheet:
1. Select all cells .
2. Create a conditional formatting rule, and select the Formula option 3.
3. Enter a formula:

=ROW()=CELL("row")

4. Select Format to put the fill color in the cells

Thanks this works! I was doing something similar to this before but it was really bogging down the spreadsheet. That's why I turned to VBA in the first place. But after recreating the Conditional formatting rule it seems to work a lot faster now!

Thanks!

 

[Rayreloj10]

Hello!

I've got the same problem. I tried your code and works the same with my code. In my case I need to highlight only the rows in my table and I have 3 different tables in the same sheet. when I clicked the cell it also highlight the same row in 3 tables. can you help me to formulate my sheet that only highlight the specific row in the specific table.

Thank you!