Hey there, fellow spreadsheeters. I'm back with a fairly simple question. I've seen many questions asking to highlight a ROW when it's selected, but I only want a cell.
So let's say I've selected any cell in row 3. In that case, I want A3 to be highlighted. 4, A4. 5, A5. And so on...
Ideally, this would stop at A60, but I could probably force that by tinkering with conditional formatting.
I've looked at the code for conditionally formatting this and just can't figure it out, which is why after an hour I'm turning to you guys. Any ideas?
So, in summary: Highlight A(x), where (x) is the row selected. Ideally not a macro so that way the colors and such aren't reset. If possible, stop at row 60.
Thanks!
Bookmarks