Conditional Formatting in Excel can be used to create a searchable database.
In this video tutorial, I will show you how to create a search bar, such that it highlights the matching entry as soon as you type and press enter. All we will use is conditional formatting and some Excel formulas.
Read the Tutorial and Download the example File:
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
THANKS. …… REALLY IMPRESSED
Just what I needed. Thank you.
"TrumpExcel is Excelled in Excel" – In simple I can say this – I mean it wholeheartedly. Apply Conditional Formatting to highlight the word EXCEL… 🙂 🙂 🙂
wonderful sir !!, I know conditional formatting basics, But by seeing this video I came to know How we can use Conditional Formatting in different Contexts.., Keep up the good work sir. U are "Excelled in Excel".
Thanks for your great work
Great trick 👍👍Please make a video on custom number formats
hi there,
history didn't play in your favor, now did it?
Is it possible to do the same with range of values?
highlight values or rows in list B if it stems from list/range A
LOVE IT! Good man!
Dear , when i copy the amounts from email and pasts the same in excel for total count in the cells, showing the many spaces in the start, how i will remove the same as the simple trim and CLT+H is not working there, Please Support. Akhlak thank you
Grt video …
Can u please give some formula to get the highlighted cell in active screen for huge data base..so that if search box finds the target then can show the same in active screen .No need to scroll up and down.
Thanks once again
its too white, the background, cant see shit idiot!!!!
This example i tried one example is getting to me but not getting output 2nd example in ms excel 2007 i have version sir … Help me sir
Dear Sir, you did great explanation Sir . this video very useful to me. I tried but not getting correctly output to me……. I need your help… In same way How can make a Search and Highlight Data in excel and auto save Data programming. For example I want to search and highlight data and auto save the data work sheet-1 in excel from What we are entering data should be save in work sheet-2/3/4… If I search the data in worksheet-1 correct display the answer. Can you Sir make a video or send the worksheet.
Thanks
Very useful info
Nice Explanation.. Thank, I have some error in my excel ledger book.. I have copied your formula's in my worksheet but iferror and index formula's are stopped after 500 rows. why??
Sir
To get all the Rawls to be selected in the last example what s the solution?
Your channel is great! Thank you so much 😊😊😊
Your teaching methods have wow factor.
very useful.
i was searching this kind of trick for one of my huge data, i am working with daily.
thanks for sharing.
Sir how to search and highlight only first word in this list of coloumn "D"
such like, When we search "India" then highlight only "D5" cell,
agein when we search "US" then highlight only "D8" cell,
again when we search "China" then highlight only "D6" cell like this.
How it is possible?