To highlight rows that contain one or more blank cells. you can conditional formatting with a simple formula based on the COUNTBLANK function.
In the example shown, the range B5:F15 is formatted with a conditional...
To count the number of cells that are blank, you can use the COUNTBLANK function. In the generic form of the formula (above) rng represents a range of cells.
In the example, the active cell contains this formula:
To count the number of cells that are not blank in a range, you can use the COUNTA function. In the example shown, E5 contains this formula:
How this formula works
COUNTA is fully automatic. When...
Because tables support structured references, you can learn a lot about a table with basic formulas. In this video, we run through about a dozen examples. It's a nice demo of how formulas and tables work together to save you time.
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.