Search and Highlight Rows in Excel

Hinzugefügt: 2026-05-18

[00:00:00]Want to create this advanced search option? Here is how to do it. Select the range where you have your data. Click on home tab and then click on conditional formatting. Click on new rules and here select use formula to determine which cell to format and then write this formula. Select the first cell that you want to search. Press F4 twice and then write equal to and then select the cell where you are going to input your search. Now format this with your preferred color and click okay. Click okay again. Now if you write here the search term, let's write John and press enter, it will highlight the row where you have your search term.

[00:00:39]Let's write here Kazi.

[00:00:45]And you can see every time I search something here, it will find that row and highlight it for me.