Here's how to highlight the entire row based on a cell value. So if we use drop-own menus here, they're only going to show the color for that drop-own menu. So we can create a drop-own menu. We can say completed, in progress is yellow, not started is red. But see, they're only showing up for that particular cell. Let's do it for the whole row . What I want to do is select the whole column , go up to format , conditional formatting , and I'm going to format the cell based on the text text contains not started, and I'm going to select the color to be red. Now, it still doesn't show the whole row or color the whole row, but I will go up here to apply to range, and I'm going to change this to a colon z.

still doesn't show the whole row because we're looking at each cell. So, what we need to do is change this to custom formula is equal to A1 equals not started and change A1 to C1 and change or add a dollar sign in front of the C. And now magically the entire row is looking at the C column because this dollar sign is holding that C still. Basically we're looking at every single column and every single row but we're looking all of those are looking at the C column. Click done. Add another rule. And again go to custom formula is equals

to dollar sign C1 equals in progress. Change the range to A to Z and change the color to yellow. Done. Now if I change this to not started, it'll change the whole row color. This even works for drop downs. Let's put back that dropdown . Let's change it in advanced options to just an arrow. Click done. And now we can do in progress. In progress, very simple to highlight the whole row based on the cell value. You're 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 going to be your next Google Sheet.