Here are the steps to search and highlight all the cells that have the matching text: I will show you how to search and highlight only the matching cells in a dataset. Later in the tutorial, we will go a bit advanced and see how to make it dynamic (so that it highlights while you’re typing in the search box).Ĭlick here to download the example file and follow along. In this tutorial, I will show you how to create this search and highlight functionality in Excel. Something as shown below (where I enter the item name in cell B2 and press Enter, the entire row gets highlighted): Now you can use conditional formatting to search for a keyword (by entering it in cell C2) and highlight all the cells that have that keyword.
It has columns for Product Name, Sales Rep, and Country. While there is no direct way to do this in Excel, you can create search functionality using Conditional Formatting.įor example, suppose you have a dataset as shown below (in the image). If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highlight cells/rows for the searched term. Watch Video – Search and Highlight Data Using Conditional Formatting