In the rule box, use the SEARCH function in such a way that if put anything we want to search in Find Text option, it will highlight those value cells with the selected color within the selected text range.

By using Conditional Formatting and Formulas we can easily create Search Box in Excel.

The amount of data can be enormous and it can be difficult to search for a particular car model name from the entire data.

A search box can prove to be a useful tool in such a case and help you in highlighting the values that you might be looking for.

You can highlight the selected cell in order to easily distinguish it from other cells.

The selected range in our case is A2: D27 (as shown in the image below).

Youll see that all the rows with the word scooter have been highlighted.

For example, now after the fields for Scooter have been highlighted, we can simply apply a filter on the color and refine our search results even further.

Now let us try to understand the meaning of the parameters that we used in the Search formula and how it worked for us in Excel.

We can either type in the cell number or we can simply click on the cell where we want the search box after we have written SEARCH in the conditional formatting rule window.

So A2 means that we wish to search for the data in column A starting from the 2 nd row.

Adding sign before A ensures that the search location remains fixed even if we change the location of the search box.

We can then specify all the search locations in the same manner as we specified for A2.

Now let us see some examples where we can use a search box and get refined results.

Consider the previous example where we had searched for the word Scooter in our Excel sheet and all the fields having the word Scooter were highlighted.

Now, what will we do if we wish to see the brand names of the Scooters that were sold in the year 2008.

There are 2 brands whose scooter were sold in the year 2008 as shown below.

There may be cases when the amount of data present in a sheet is huge.

A Search Box can help us in all such situation as it creates a search criterion for the entire sheet.

Make sure that you do not put the sign at the end of the formula.

A Search Box in Excel can be used to enhance the function of a filter.

Here we discuss How to Create Search Box in excel and Usage of Search Box in Excel along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Search For Something In Excel Mac