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.
- So apply the above-given formula in the conditional formatting option.
- To know how to apply conditional formatting in Excel, just refer to this article: How to Apply the Formula with Conditional Formatting In Excel?
- Finally, it will highlight the result and displayed it as shown below.
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 *!!
Top comments (0)