DEV Community

loading...

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

excelgeek profile image 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

Highlight rows that contain blank cells
Highlight rows that contain blank cells

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.

Input Ranges
Input Ranges

Result
Result

Verdict:

In this article, we have described the simple formula used to highlight the rows that contain blank cells in Excel. Please share your feedback about this article. Thank you so much for visiting our site. Click here to know more about Geek Excel *and Excel Formulas *!!

Read Also:

Discussion (0)

pic
Editor guide