Search Bar

When using the search bar on a specific sheet to locate all the rows that match, is there a way to highlight all of those rows from the search within the sheet?

I have a sheet with almost 11,000 rows and don't want to go row by row to locate and highlight them and copy them to another sheet.

Thank you in advance for your time, attention and help!

Answers