00:00Have you ever seen anything like this in Google Sheet, where you input a few characters on your
00:04search box to find a student name, and it dynamically highlights the row where the
00:08student name was found and also indicates precisely which characters matches your search query.
00:12Allow me to demonstrate how to achieve this functionality.
00:15To begin, select Extensions and then App Script. Next, paste this App Script into the editor as
00:21shown. If you need a copy of this script, please leave a request on the comment section and I'll
00:24direct you on how you can get it. You will have the option to customize the first four line of
00:28the script. Cell Search Text refers to the cell location of the search box. Found Row Highlight
00:34Color is the designated cell fill color for the found row. Found Text Color represent the font color
00:39of the text where the search text was found, and Column Search indicates the column containing the
00:44student name in the data set. After that, press Ctrl-S to save, and then let's close the Apps Script
00:49editor, and finally, perform some tests.
Comments