It doesn’t have to be, just curious if there was a way without it. I’m open to using VBA if I must.Can I ask why vba must be avoided?
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.It doesn’t have to be, just curious if there was a way without it. I’m open to using VBA if I must.
Thank you, this what I needed.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.