So you wanna highlight an entire row based on the text in one cell in one column. In this particular case, we're looking at roles in a column, and we're saying, " Where does it say VP? Highlight the entire row . I'm gonna show you that right now In the B column we have VP of marketing, chief marketing officer. I just wanna highlight the s- cells and the row where it says VP. So I'm gonna select the B column, and if I do, I'm only going to do the conditional formatting for the B column. I actually wanna do however much range of that row I wanna do. If I wanna do the entire sheet, do the entire sheet. I got to highlight it. Format, go to Conditional formatting. Over here on the right, I'm gonna make one little change, is I'm gonna change it to A2 so I don't highlight that first row. Anders Asks: Can I Highlight Whole Row if Certain Columns have text? The Simplest Bestest Checklist in Google Sheets Highlight Row as You Move Your Cell Selection Highlight Entire Row with Conditional Formatting

Then the format rules is going to change to custom formula Here we're gonna equals SEARCH We're gonna be searching in quotes for VP The new comma B2, end parentheses. And if we notice right now, it's just highlighting the A column. The trick is we need to add a dollar sign in front of the B so that every single cell and every single column is gonna look at the B column and say, "Based on that, are, do we find the VP?" And we can change our cell highlighting, even change the text color a little bit That's how you highlight the row based on the text in a cell. Click Done and we got it. The entire sheet is like that You're watching Better Sheets here on YouTube. Study Better With Google Sheets The Simplest Bestest Checklist in Google Sheets EVERYTHING you need to know about Conditional Formatting

Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments . And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Sheets doing things in Google Sheets you never thought possible. Go check it out Better Sheets Members Tour March 2026 Absolute Basics of Google Sheets Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. How To Sell Google Sheets For Fun And Profit