macro

[chazzerman01]

does anyone know a macro code that will highlight the whole row that the cursor is on. im using it to make it easier to read values in a table

 

[KOKOSEK]

I know. Nobody mention that there is any hardcoded fill inside.
You were right that first solution was not so good because it clearing existed CFs.

 

[jasonb75]

There might not be any hard fill in the cell, quite often important details don't get mentioned because people don't always realise that they will be relevant to the suggestions that will be offered.

I offered a suggestion similar to yours in an old thread, problems arose there because of pre-existing formats.

I prefer your methods for the visibility that is offered, but using selection to highlight the row is less likely to conflict with anything else.

It might be possible to add and remove single conditions from a range without affecting existing rules. If that can be done then I think that it would be the 'winning' method.

 

[KOKOSEK]

Absolutely agree. As in 99,9% there is no enough details in OPs posts.
Usually I try to give the simplest solution. Obviously, it can interfere or damage on sheet but due to lacking of details, as above, it can't be predicted.
I never said that your macro is wrong or works incorrect.

 

[chazzerman01]

@KOKOSEK is it possible so that when the highlighted row goes over a row that already has coloured boxes, that instead of resetting the boxes to no fill it keeps the colour that was originally there

 

[KOKOSEK]

It is but what if you got lots of hardcoded colouring in row ?
Ex. col A, col. D, col. AA, col. FD ? It need to be kept to reverse it back.
If you want to 'highlight' active row maybe you can consider other way like bolding fonts (I believe that you've got something in rows) or something else.

 

[chazzerman01]

basically this is my table, I just want it so that when you move the cursor it temporarily highlights the cells in that row until you move the cursor but when I used your code it changed all the colours to no fill, but if it's possible I'd like it to keep the original colour of the table

 

[KOKOSEK]

What you don't want to use Jasonb75's solution?

 

[chazzerman01]

I just tried it and it didn't work

 

[chazzerman01]

your one works it just resets the colour in the box

 

[KOKOSEK]

Try like this. Make the same colouring of column in row 100 000, what's no colour, no colour, in E/F/G/H/I make a colour as in your table.
Check range IMHO you do not need colouring full row (A:XFD) so set range A:O in code below:
Then:

Public OldTarget As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim cell As Range
    
    On Error Resume Next
    For Each cell In Range(Cells(OldTarget.Row, "A"), Cells(OldTarget.Row, "O"))     ' set range
        cell.Interior.Color = Cells(100000, cell.Column).Interior.Color
    Next cell
   
    Range(Cells(Target.Row, "A"), Cells(Target.Row, "O")).Interior.Color = RGB(255, 255, 0)    'set the same range as above
    Set OldTarget = Target
End Sub

probably could be done better and more efficient but it works.