So I just wanna highlight in column B if it's larger than column C, because this is the hours I've worked, and this is in column C, the hours that people have paid for. So if I'm over hours, I want to bill that client or bill them for some overtime. So what I'm gonna do is I'm gonna select the column that I want highlighted. I'm gonna go up to format . And do conditional formatting . And now over here you can see that it applies to range B one to B 1000. I actually just want B three to be the start of this, so I could change that, but I will change this later as I'm gonna show you something really cool. Format rules . I'm gonna change to custom formula is . And I'm gonna do a little bit of a weird formula or weird syntax ,

but you'll see I'm gonna do equals B one is greater than C one. Why this equals sign at the beginning is because I'm saying this custom formula is like, it doesn't really mean equals, it means is in this case. And I'm saying this is the formula that I want to look at, is B one greater than C one? And you can see right away that it's. Sort of correct. You can also see that B one and B two are highlighted as well, so that's why I like to change B one in the range to B three to my actual rows, but that also means that the highlighting turns sort of wrong. It's, it's incorrect because I need to change B one in the formula to B three and C one to C3.

These custom formula is actually sort of tied to that range , and I can also change the color if I want, maybe red, and I can change the text color to, let's say white, to really have some high contrast. But this allows me to see very quickly if I go over hours, immediately turns. Red. 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.