So you can add alternating rows of color very quickly, even one line at a time as you add them, like one more line here and another one more line here. As you add text, it'll automatically add those alternating rows. I'm gonna show you how go to Extensions app script . It's gonna be one line of code. However we need to change our function name to on edit with a capital E. Make sure that E is capitalized and we're gonna just write one line of code spreadsheet app. Do get active spreadsheet . Make sure you add that parentheses, get data range . Parentheses, make sure you add the parentheses. Apply row banding and parentheses. That is it. Those four functions altogether with the dots saying, in this spreadsheet file,

get the data range and apply row banding . And it's gonna be very basic. It's going to be this particular gray. You just have to save either command S or click the project button up here. And once you do that, then you can add some text. Some more text and more, and it'll change the entire data range . So that's only da. That's only the range that has data , right? So you see column fg and all of these rules do not have that. I. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here.

Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.