In Excel 2010, hoping to highlight all the cells in a range (about 100 cells) that match whatever's in the cell I'm currently in. All cells contain plain text (cells in the range being highlighted, and cells in the range being navigated with the cursor, and the two ranges do overlap).
Been fumbling around with variations on INDIRECT(), CELL(), ROW(), and COLUMN(), ... but no luck. I seem to get either everything always highlighted, or nothing ever highlighted.
Any help greatly appreciated!
To the best of my knowledge (and I have been wrong many times lol), excel on its own (as in, just by using regular formulas), does not know what cell it is in.. I thknk you will need some-one to put some VBA code together for this
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello ottenm,
As FDibbins says:I think he is right.I think you will need some-one to put some VBA code together for this
Please see if you can make do with the attached sample WorkBook.
Also see the "Please consider" note at the bottom of this post.
Last edited by Winon; 06-27-2013 at 05:51 PM. Reason: Improved Code
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello ottenm,
Did you manage to come right with your issue?
wow that takes me back....did you come right....such an SA expression
@ FDibbins,
Thank you for the feedback, and the "Rep."
I truly was not aware that ...did you come right...is such an SA expression! Should I rather avoid using it?
No, I think its cool, and describes the question very well...kinda like spookassem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks