COUNTBLANK function in Excel

Excel provides predefined formatting options for font size, color, line spacing, alignment etc that allows users  to quickly style worksheet cells.

Highlight rows with blank cells in Excel

This tutorial shows how to Highlight rows with blank cells in Excel using the example below; Formula =COUNTBLANK($B5:$F5) Explanation 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 formatting rule… read more »

Return blank if in Excel

This tutorial shows how to calculate Return blank if in Excel using the example below; Formula =IF(A1=1,B1,””) Explanation 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: =IF(B5=1,C5,””) How this formula works This formula is based on the IF function,… read more »

Count cells that are not blank in Excel

This tutorial shows how to Count cells that are not blank in Excel using the example below; Formula =COUNTA(range) Explanation 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: =COUNTA(B4:B8) How this formula works COUNTA is fully automatic…. read more »

Count cells that are blank in Excel

This tutorial shows how to Count cells that are blank in Excel using the example below; Formula =COUNTBLANK(range) Explanation To count the number of cells that are blank, you can use the COUNTBLANK function. In the example, the active cell contains this formula: =COUNTBLANK(B4:B8) How this formula works COUNTIF counts the number of cells in the range… read more »

Sidebar