How to Highlight Text in Google Sheets (The easy way, and with conditional formatting!)

Published: 15 July 2024
on channel: Spreadsheet Point
2,089
5

Full Guide: https://spreadsheetpoint.com/formulas...

If you've ever wanted to highlight text in Google Sheets, here's the easiest way to do it.

I'll show you how to use the REGEXMATCH function, how to nest it inside of an IF function, and how it looks when you highlight your "TRUE" statements with conditional formatting.

00:00 Intro
00:09 REGEXMATCH to Check for Text
01:15 Checking for Partial Text

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos -    / spreadsheetpoint  

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

You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/

#spreadsheetpoint #googlesheets #googlesheetstips #spreadsheetmastery