 Hi, this is Matika Parker and I am going to show you how to use conditional formatting in Google Sheets. Starting off, I'm going to show you the different ways to access Google Sheets. One way is if you open up a new tab, you can type in your search bar sheet.new And press enter and that will open up a new Google Sheets for you. Or you can go over to your waffle here for your Google Apps and select Sheets. And then of course after that you press blank and it will start a new sheet for you. Okay, so I'm going to go ahead and title this Google Sheet as Food in Spanish. And I'm going to create this little quick check for students. I'm going to select this first cell here and I will drag it out to select more. And I'm going to go up to my format toolbar. I'm going to choose text wrapping and just make sure that that wrap is selected. Also, I am going to stay up here in my format toolbar and I'm going to click merge cells. As you see, whatever I clicked on my cells instead of having 16 cells that I have selected, they all merged into one large one. This is going to be where I'm going to type my directions for this activity. Okay, so after I type my directions and click off of it into another cell, you can see here that my direction box, the text in it is a little small. So you can click back into it and you can of course enlarge it. And you can also change the font. I personally like Ubuntu, so I'm going to click on that. Also, a cool thing is, notice when I clicked off of it earlier, it all is just kind of like pushed down to the bottom. So if you go back up to your format bar and you click vertical align, this little alignment tool, you can change it to just be more centered. So like, it looks like that as well. But that's just a personal preference for me. Now I am just going to create these columns. And now that I'm thinking about it, I kind of want these to be blended, or at least larger. So what I can do is I can select this column B right here, and I can completely delete this column. And notice what it did whenever I deleted that column, it didn't get rid of my direction. And it didn't get rid of what I had written for my Spanish and my English terms. Now what I'm going to do is I want my columns here to be larger. So I'm going to select my A column here. And I'm going to hold down my control key and also select B, since I will only really need these two columns. And now that they're selected, I can go to any of these lines here and pull and resize these columns. And that does that to both columns, so I don't have to worry about, like, clicking and dragging and trying to see if they are actually the same size or not. Also, I guess I didn't think too far ahead of this. I don't really need this column either, so I'm going to go ahead and delete that. And then now I have really what I need. You could go here to select all of these cells in your spreadsheet. And again, if you did that, you could change the size of your rows. You could change the size of your columns, and they all will end up looking like that whenever you do that. You can even change the font to all look the same. So all the things that I did earlier where I did like text wrapping and changing the alignment. Spanish and English don't have enough space here, so I'm going to change those. So now I am going to fill in these words in Spanish. I'm going to center those. So now here comes the formatting. So what I'm going to go ahead and do is I'm going to click underneath my English column. Let me center these as well. I'm going to click under my English column right next to the word that means onion. And I am going to go to Format and Conditional Formatting. And it's going to open up this little menu for me. And so you want to do B6 to B13. You can do that. I'm going to select all of them. And so let's say if text empty, then let's say you can turn these to be yellow. And so what that does is because these cells are empty, they have been changed to a yellow background. And then you could do done. I'm going to add another rule here. And I'm only going to have B6 selected this time because this is where it gets really important. So I'm going to say Format Rules, Text Contained. And then underneath that it's going to open up a value or formula underneath the text contained far now. I'm going to type the word onion here because that is the word that needs to go here in order for the students to get it correct. And so by default, it will turn this green. And you can change it to whatever green you want, whatever color you want. You could customize the colors down here. I am just going to keep the theme of these kind of like pastel colors going, I guess. And I won't change the screen, but if you would like to, you could. And then I will close down and do done. Then I'm going to add another rule and you do not have to do this. But I always like to because it's easier for the students to be able to see if they need to change anything. So again, B6 is selected. I'm going to underneath Format Cells If. I'm going to open this drop down menu again. And I'm going to do if text does not contain type onion again. And now with my does not contain, I'm going to change that background. I'm going to change that background color. I'm going to hit this paint bucket and I'm going to turn it red. So now that I've done that, notice that the cell B6 is empty, which means that it needs to be worked on. If I type in the word onion and I click off, then it turns green. If I go back and get rid of it, it automatically goes back to being yellow because it's empty again. But let's say that I think that this means potato. When I click off of it, it turns red. And this is a quick way for students to just kind of check themselves and see if they have their answers correct or incorrect. So that yellow is just letting them know, OK, it's empty. It needs to be worked on. You type in your word. If it's correct, it will turn green. If not, it's going to turn red. And we can do that for all of these other words. So I'm going to show you that again. I'm going to go to B7. So quick B7 format up here in the toolbar. Conditional formatting. Remember that we already selected this whole range from B6 to B13 to remain yellow as long as the cell is empty. So we don't have to do that again. We're going to add another rule. We're going to go underneath the format cells if and we're going to do text contains. We are going to type for this one, potato. And we do want it to go green. I'm going to add another rule. Hit this drop down menu again. If text does not contain potato, we are going to turn this red. So let's say they think that this word means onion. When we click off of it, it turns red. That's the red flag. They know that they need to go back and change it. And you may be wondering if it matters how they type the words like do uppercase and lowercase letters matter. No, they don't. I can type O, capital O, lowercase in, capital I, so in. And it will still turn green. So that is how you do conditional formatting to do quick checks with your students. Thanks for watching. Don't forget to like and subscribe.