Excel feature? If not maybe make one?

[IamDavid]

Not sure if I can explain what I want but here it goes...

When working in a spreadsheet I want the row and colum of the slected cell to change colors, highlight.

Like this..


sssssssssssssssssssssssssssssssss
sssssssssssssssssssssssssssssssss
sssssssssssssssssssssssssssssssss
ssssssssssssssssssssssssssssssss
sssssssssssssssssssssssssssssssss
sssssssssssssssssssssssssssssssss
ssssssssssssssssssssssssssssssssssssssss
ssssssssssssssssssssssssssssssssssssssss
ssssssssssssssssssssssssssssssssssssssss

Can it be done?

 

[mayest]

You could do it in VBA pretty easily, but I would guess it would slow Excel down quite a lot since you'd be doing a bunch of reformatting everytime the active cell changes.

Might be able to do it with conditional formatting, but I can't think of a formula off the top of my head.

BTW, I assume that you know that the column and row headers do get highlighted when you change cells. I guess you must have some reason to do this, but I can't figure it out.

 

[letdown427]

Do you mean change colour so something like red or whatever? I.E whereby you'd have to format all the cells every time? Or do you just want it to highlight (in the normal grey) the whole row and column for whatever cell you select? The second option would be again simple to do in VBA, but would also show virtually no difference in performance (I should think)

 

[IamDavid]

"Or do you just want it to highlight (in the normal grey) the whole row and column for whatever cell you select?"

That's pretty much all I need. It's all so I can kep track of where I'm at better..

 

[mayest]

Ok, here you go. Copy and paste the code below into the ThisWorkbook module of any workbook that you want to use this on.

Personally, this isn't to my taste, but I coded it just to see how it would work. Let me know if you have any questions.

Tim