## DEV Community is a community of 623,823 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

# Excel Formulas to Highlight the Rows with Blank Cells ~ Easy Tricks!!

Andrews Originally published at geekexcel.com on ・2 min read

Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it. But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row based on some condition. In this article, we provide cute formulas to highlight the rows that contain one or more blank cells in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

## General Formula:

• Use the below formula to highlight the rows with blank cells.

=COUNTBLANK(\$B5:\$F5)

## Syntax Explanations:

• COUNTBLANK – This function returns the number of blank cells from the given input range and returns the output in number. Read more on the COUNTBLANK function.
• Absolute Reference (\$) – The Absolute Reference (\$)is an actual fixed location in the Excel sheet.
• B5:F5 – It specifies the input range from your worksheet.
• Concatenated_columns – It represents all the column values from the same row.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

• Here, we will enter the input values in Column B to Column E.
• Now we are going to highlight the rows that contain blank cells.