98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Highlight results of Excel find function
Highlight results of Excel find function
Resolved · Urgent Priority · Version 2010
Wed 5 Oct 2011, 14:35Delegate Lydia said...
Lydia has attended:
Excel Introduction course
Highlight results of Excel find function
Please could you tell me if there is a way to immediately highlight cells that contain certain text using the find function?
A conditional format won't work as this will be used to check names off a list of 3000 at a party (taking place on Friday) as guests are coming in, and it needs to be fast. The find function works, but it is not instantly obvious where the cell is
thank you
Wed 5 Oct 2011, 16:35Trainer Andrew said...
RE: Highlight results of Excel find function
Hi Lydia
Thank you for your question. I'm not aware of a way Excel can do this. Word 2010 has a useful feature where the search results are highlighted as you type both in the document and in the navigation pane. It may be worth pasting your list from Excel into Word for tracking arrivals on the night. Try it with some test data and calling up find (Ctrl + F)
As this is not an Excel answer I have left your question unresolved. I'll see if I can think of any alternatives that are Excel based.
I Kind regards,
Andrew
Tue 18 Oct 2011, 13:22Delegate Barry said...
RE: Highlight results of Excel find function
Lydia, I only have 2003 on my desktop but if you have Mad Hatter for example in your worksheet & you want to find & colour Hatter you would:
Ctrl+F
In the "Find What" put Hatter
Select Replace
In the "Replace with" put Hatter
Select Format
Then Font
Then Colour, say RED
Then select Replace or Replace all.
The only stipulation is that the word you are wanting to colour must be in it's own cell so Mad would be in one cell & Hatter would be in another.
Remember this is 03 but should still work in 07 & 10.
Baz
Wed 19 Oct 2011, 12:51Trainer Simon said...
RE: Highlight results of Excel find function
Hi Lydia,
I am currently going through all the outstanding posts and came across your post.
Did you manage to resolve the highlighting problem for the party mentioned in your post?
Regards
Simon
Wed 19 Oct 2011, 13:43Delegate Lydia said...
RE: Highlight results of Excel find function
Hi Simon,
Not in Excel, we ended up doing as Andrew suggested and pasting into Word, but as there was a lot of data is caused system crashes a few times, so it's not ideal.
The second suggestion from the delegate is too time consuming to use, it really needs to be an instant result, as it is in Word.
Many thanks
Lydia
Wed 26 Oct 2011, 13:28Trainer Simon said...
RE: Highlight results of Excel find function
Hi Lydia,
Thank you for your response.
The only way of doing it efficiently is through VBA code.
Please find the link below which contains VBA code and instructions of how to use it. You run the macro and it asks you for search criteria;once the criteria has been entered and you click OK, it will highlight the results for you.
http://www.pcadvisor.co.uk/forums/1/helproom/305437/excel-2003-help--how-to-highlight-search-resukts/
You would have to open the workbook and do ALT+F11 to open up the VBA application. In the Project Explorer Window on the left hand side of the screen, choose VBAProject followed by your workbook name and click on the + symbol next to it. Then go to the Insert Menu and choose Module.
Double click on the new module and copy and paste the code from the website into the new blank window.
Close the window from the top right hand corner. To run the macro, use ALT + F8 to list the macros box. Double click on the FindHighlight macro.
I hope this helps.
Regards
Simon
Tue 1 Nov 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |
