Excel Conditional Formatting can be used to create a search box in Excel.
You can use the search box to search for an item and it will highlight that data point (or that row) as soon as you enter anything in the search box.
In this video tutorial, you will learn how to create a dynamic search bar (or search box) in Excel such that the matching data set gets highlighted whenever you enter anything in the search bar.
This technique uses conditional formatting, helper columns, and Excel formulas (SEARCH, ISNMUBER, IFERROR).
Step-by-step tutorial and download file:
You May Also Like the following Excel Video:
—
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Very helpful 👍
Want to do this for crosstabulated data with numbers only. Something similar to e-commerce store where I can choose price range of phones for example .
Can you help with a video on the subject
I have no knowledge of coding
Can we display the result for exact match and display it(eg when i type 15, show only 15 not 115)
Awesome Video… One thing i want to know what does it makes a difference if we press ctrl+shift+enter.
Just as brilliant in 2019. Thank you for all you do. So satisfying when my rows lit up!
Amazing thank you
Thanks … Thanks.
Hi Sumit.. great video and very creative use of the ActiveX Text Box control to make a search bar and make it dynamic. I have seen this type of solution in the past, but VBA. Very nice to do it with no code! Thanks and Thumbs up!
I tried to create dynamic list but it seems not working with list on country code and price list together. Need help
Great! Is there a formula to hide rest of the data when you search. Long list of data, i don't want to scroll down to see whats highlighted. I would like all the rows highlight to come to the top or auto hide rest of the data
Great tutorial. Will try it without the combo box for better office online compatibility.
Thank you, thank you for this tutorial. I have been searching for something like this for a while now and I've now found it…hooray!! However can you please explain how to leave the highlighted row highlighted each time you search. Thank you
What if i have lot of data…
And i want excel to take me up to the search row as well also highlighting it
Not working with large data set
I.e if my data is 20000 + it is taking around 5 minute to identify
I like your video ,I want same method and VBA code like scerch bar and data display into listbox using VBA programming in excel any same thing you have please share with me
Dear Sumit,
I know you must be b
usy & you may not reply.
Others who can help.
Please suggest…
I have 5 sub sheets (at bottom you get a option of adding more worksheets, i dont know what to call them. So sub sheets)in one worksheet. All 5 sub sheets have some data…which is in same format. Now i have made a homepage or a cover page .
On cover page i want a search button, by entering a name or there token no. one can find there details
This is awesome
Superb
thanks, finally I was successful in my 21st trial, feel great.
Thanks, that's really informative.
Hello Trump thank you for taking the time to make this brilliant excel tutorial available.
HI THERE,
FIRST I WOULD LIKE THANK YOU FOR SHARING US EXCEL TIPS.
MY QUESTION IS I HAVE TRIED TO WRIGHT BUSINESS LETTER
IN EXCEL AND I AM ABLE TO SEE IT IS POSSIBLE.
SO, IT IS MY PLEASURE IF I GET SOME MORE.
THANK YOU.
After some trials, I found a solution to this bug.
New Formula:
=AND(search_box<>"",OR(ISNUMBER(SEARCH(search_box,rows_you_want_to_be_highlighted))))
Demonstration:
=AND($C$2<>"",OR(ISNUMBER(SEARCH($C$2,$B5&$C5&$D5))))
Brilliantly explained. well done.
Outstanding