How To Highlight Whole Row if Any Cell is Blank
Learn how to highlight an entire row in Google Sheets if any cell within that row is blank, using conditional formatting and custom formulas.
In this video, I'm going to show you how to highlight a whole row if any cell is blank. So this means if we even have a blank month or a blank sales, anything, or multiple blanks, the entire row is highlighted. I'll show you how to do this. We're going to go up to format , conditional formatting . We're going to add a rule. Our rule is going to apply to the entire range , A to H, A to G here. We're going to change the format rules to custom formula . We're going to create a formula where we're going to count all of the items in a row, and then we're going to compare it to how many columns there are. So we're going to do count A. We need to do A1 colon G1. And we're going to say, is it less than columns A1 colon G1? to G one.
Now what's gonna happen is this A one and G one is gonna change as the conditional formatting goes down. So we actually want to in front of A and G. We want to put a dollar sign to lock them in. So A and G and that way. The entire row is highlighted as it goes down. And now, if we change this to May, we see that this is unhighlighted.