Excel Formulas to Highlight the Rows with Blank Cells ~ Easy Tricks!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-04-03 10:51:39

---
title: Excel Formulas to Highlight the Rows with Blank Cells ~ Easy Tricks!!
published: true
date: 2021-04-03 04:24:04 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-highlight-rows-with-blank-cells/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Highlight rows that contain blank cells](https://geekexcel.com/wp-content/uploads/2021/04/Highlight-rows-that-contain-blank-cells.png)](https://geekexcel.com/excel-formulas-highlight-rows-with-blank-cells/highlight-rows-that-contain-blank-cells/#main)<figcaption id="caption-attachment-22802">Highlight rows that contain blank cells</figcaption>
## General Formula:

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

**=[COUNTBLANK](https://geekexcel.com/how-to-use-excel-countblank-function-in-office-365/)([$B5](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/):$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](https://geekexcel.com/how-to-use-excel-countblank-function-in-office-365/)**.
- **Absolute Reference ($)** – The [**Absolute Reference ($)**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)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](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-2.png)<figcaption id="caption-attachment-22803">Input Ranges</figcaption>

- 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<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight the result and displayed it as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-2.png)<figcaption id="caption-attachment-22801">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Highlight Target Percentage with Conditional Formatting](https://geekexcel.com/excel-formulas-to-highlight-target-percentage-with-conditional-formatting/)**
- **[Excel Formulas to Highlight the Cells that Equal to Certain Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-equal-to-certain-criteria/)**