Now you can search for the desired keyword, and you will see that all the rows with the word you have searched for are now highlighted with the selected color.įor example, let’s try searching for the item named Scooter.A screenshot of the same is also given below. After this, click on OK, and you will see that all the fields in your sheet are now highlighted with the color that you selected.This can be done by selecting the Fill button on the next window and selecting the color. After writing the above formula in the space provided, click on the Format button just below it to select the color in which the searched (and matched) values will be highlighted.On the next window, click on the option that says, Use a formula to determine which cells to format.Īfter this, enter the following formula in the text box just below it.Once you have selected the entire data range, go to Conditional Formatting, select New Rule.The selected range in our case is A2: D27 (as shown in the image below) Now select the entire data range from where you want the data or the value to be searched.You can highlight the selected cell in order to distinguish it from other cells easily. In this case, we have selected G1 as the search box cell.
The amount of data can be enormous, and it can be difficult to search for a particular car model name from the entire data.
EXCEL HOW TO MAKE CHECK BOXES LINKED TO CELL DOWNLOAD
You can download this Search Box Excel Template here – Search Box Excel Template Usage of Search Box in ExcelĬonsider that you have the data of a company that deals in the sale and purchase of used vehicles.