Hello, I have a worksheet with lots of data on it, resulting in a very busy layout. I have been using "FIND" to search for various numbers within the spreadsheet, however often times it is hard to see which cell "FIND" selects.
Is there a way to enable Excel to highlight the selected cell? For example could "Find" turn the cell yellow when it finds a match?
Thanks in advance for any suggestions
I found this but when I log in to see how to do this item be able to colour 'find' so the cell is more visible it takes me I don't know where and I can't see how to do it?
This code give the user a inputbox
Select Code copy to clipboard
Please Login or Register to view this content.
VBA Noob
Reply With QuoteRegister To Reply
06-12-2008, 03:31 PM #12
Stuie Stuie is offline
Forum Contributor
Stuie's Avatar Join Date
09-17-2006
Location
Suffolk, UK
MS-Off Ver
Excel 2003/2007
Posts
432
hi again,
i have attached a simple example of a custom find form i have made that will mark all cells with an EXACT MATCH in the colour red.
feel free to alter it or change it.
i havnt error checked it fully but this should work nicely if you keep it simple lol.
any questions PM me as its easier
Select Code copy to clipboard
Please Login or Register to view this content.
EDIT:
you will need to save the demo i think and to show the form press Ctrl+q
Attached Files Attached Files
File Type: xls Find demo.xls (32.0 KB, 800 views) Download
Bookmarks