Search and Highlight Data in Google Sheets

In this video, learn how to search and highlight data in Google Sheets using conditional formatting

00:00 Intro
00:14 Highlight Matching Cells
01:50 Highlight All Matching Rows
03:32 Highlight Partial Matches

If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points.

For example, if you have a list of students and their marks, it can take some time to find a student's name and all his/her marks.

In this video, I will show you how to search in Google Sheets and highlight the matching data (cells/rows).

The video covers the following:
-- Search and Highlight Cells with the Matching Data
-- Search and Highlight Rows where there is a Match
-- Search and Highlight Rows with Partial Match

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

#GoogleSheets #GoogleSheetsTips #Spreadsheet

Search in Google Sheets, Search Data in Google Sheets, Search and Highlight Data in Google Sheets, Conditional Formatting, Conditional formatting in Google Sheets

[SpreadsheetPoint]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.

[markaaroneugenio]

Thank you for this man. Keep uploading videos like this

[schoolstaff]

your channel is so underrated, every single of your videos is so usefull

[ihdka]

Thank you a lot. Due to your video, I solved my problem.

[vuac]

This tut is very useful. Thank you very much.

[mikavandewiel]

is it possible to pull the input data from another tab?

[BigMikeyMike]

I would appreciate if you would explain more about the background, why it works the way it works. Its pretty difficult to understand the why behind it.

[soumendas]

Sir, will you please explain how to count number of formatted cells that are highlighted with conditional formatting and not highlighted differently

[mehtaanil]

Sir I want that if there is long data and I want to search unique Id then the cursor should go to that row and highlight the row sir can u make a video on that such as we do in find and replace option

[brianmorrison]

Is there a way I can change the highlight colour and line thickness to show the current cell.
The current blue outline is proving quite hard for me to see.
thanks !

[umkadverts]

bhai is specific word walay saray cells ko aik sath copy karnay ka koi tareeqa hay?

[nikeshsangale]

how to do that in android using application
please give me reply fast

[vernavong]

This formula only chooses for us, but it does not lead us to what we choose ! how to create search and lead to the cell we looking for ???

[guifmurb]

How to make cells go blank again after i've deleted the text on the box in the partial match?

[hariomsuman]

I have an issue in google conditional formating, how can i approch you so i can explain the problem.

[yogeshdewangan]

Bhai india se ho to hindi me banao sabhi ko english nahi aati

[jmelcher]

no disrespect to your video, but "ctrl F" is much simpler