Highlight row when cell is selected without VBA?

[caaronh85]

Hello everyone, is there a way to highlight the row of the cell I'm working without VBA? I have a sheet named Repairs as seen in the my image and it would be much easier to read the data if the row was highlighted.

 

[Peter_SSs]

Can I ask why vba must be avoided?

 

[caaronh85]

Can I ask why vba must be avoided?

It doesn’t have to be, just curious if there was a way without it. I’m open to using VBA if I must.

 

[AC PORTA VIA]

is this what you are looking for

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

 

[Peter_SSs]

It doesn’t have to be, just curious if there was a way without it. I’m open to using VBA if I must.

I don't think that you can do it without vba. If allowing vba you could try like this. It is very similar to the method in the thread linked to by AC PORTA VIA but does highlight the row as you requested, not just the active cell. It also has detailed steps if you need them. Since you have not asked for the column to be highlighted as well, you can leave out step 3.

 

[AC PORTA VIA]

to highlight the row use =ROW()=CELL("row") for conditional formatting -(don't forget code in sheet module from the link in post #4)

 

[AC PORTA VIA]

just notice that is the same as

Peter_SSs link​

 

[caaronh85]

I don't think that you can do it without vba. If allowing vba you could try like this. It is very similar to the method in the thread linked to by AC PORTA VIA but does highlight the row as you requested, not just the active cell. It also has detailed steps if you need them. Since you have not asked for the column to be highlighted as well, you can leave out step 3.

Thank you, this what I needed.

 

[ISY]

Hi

Use sparklines to show Highlight row