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 return a blank result using the IF function, you can use an empty string (""). In the example shown, the formula in D5 (copied down) is:
How this formula works
This formula is based on...
To count the number of cells that are blank, you can use the COUNTBLANK function. In the example shown, the formula in cell E5 is:
Because there are two empty cells in the range, COUNTBLANK...
To run a formula only when one or more cells are not blank, you can use the IF function with an appropriate logical criteria. In the example shown, the formula in E5 is:
The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.
Excel Formula Training
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.