Highlight entire row when cell selected or being edited

[dim4x4]

Hello!

I want to have an entire row highlighted when I select or edit a cell in that row. Then when I select or edit a cell in a different row, I want initial row "unhighlighted" (i.e. returned to previous state), and the new row highlighted. Basically, I want to see which row I am working on right now.

Thank you!

 

[Saurabhj]

Hi,

Check below code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ActiveSheet.Range("1:200").Interior.Color = vbWhite
    Target.EntireRow.Interior.Color = vbYellow

End Sub

 

[dim4x4]

Hi Saurabhj!

Thank you for the code! It kind of does what I want to do. However, it removes all other highlighting in the sheet and makes it white. I don't want to do that. I want to have the selected row in yellow, but as soon as I select another row, I want that previous row to go back to its previous highlighting. It may have some cells green, some cells light blue, etc., I want to revert to that as soon as I deselect that row. Also, is it possible to have a macro that turns on this feature. And a macro that turns it off?

Thank you!

 

[AC PORTA VIA]

check this out

colour cell background on selection then revert when move elsewhere

Merry xmas all and happy new year ! I have searched the internet and this forum with no luck so can anyone help me please ? I would like to be able to click on a cell and the background goes to a light grey, when I have finished entering data and click elsewhere the cell returns to original...

www.mrexcel.com

 

[dim4x4]

Hi AC PORTA VIA!

Works great, but it changes only a cell highlight. How can I do it for the row?

Thank you!

 

[Fluff]

use

=row()=cell("row")

for the CF formula

 

[dim4x4]

Wow! Thank you very much, Fluff!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[dim4x4]

Dear Fluff!

One more question. How do I make a macro which turns on highlighting rows, and a macro that turns it off?

Thank you again for your help!

 

[Fluff]

You can't not really. Whilst you can disable the selection event the CF will still trigger if you make any changes to the sheet.