Magic Search and Highlight in Excel | Step by Step tutorial

Hello Friends,

In this video, we have explained how to create a magic search and highlight in Excel using Conditional formatting, ActiveX control and form controls in Excel.

Below is the download link for this file:

Subscribe our new YouTube Channel:

Need Consulting Servicing in Power BI, Excel or VBA:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store

[rameshkunda]

Could you please do the Data Analysis on Real Estate Project.

[MohamedIsmail-hwil]

What about if i want to hide the table and only show the search result ?

[unwantedperson]

Hi PK, just want to know if there is possibility using search bar but instead of highlight it will filter the selected search?

[markdavies]

I am having trouble downloading the example spreadsheet from the PK web site

[tylertheexplorer]

Hello, I tried this one. It is nice and useful however I couldn't copy paste the formula to create new manager

[hinata]

PLEASE HELP
what if I search from sheet 1 using 3 textboxes the project, date from and date to the data from sheet 2 table. Once I click the button the last name, first name and middle initial from sheet 2 in 3 different columns will be concatenated into 1 column in sheet 1, along with it is the rating and final rating will be displayed in sheet 1.

I don't have office 365, I only have office 2016 so filter function is not applicable for me. Thanks

[ExcelExplorers]

I could use your assistance in my work? Could you provide some guidance?🙂🙏