Excel Formulas to Apply Conditional Formatting For If Column is Blank!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-11 11:53:24

---
title: Excel Formulas to Apply Conditional Formatting For If Column is Blank!!
published: true
date: 2021-03-11 11:51:24 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-for-if-column-is-blank/
---

Assume that you have a list of ranges with some blank cells, and you performed certain actions and have received the results. Now you want to highlight the result values that are derived by including the blank values. In this case, what would you do? Here we will show how to **apply the conditions formatting to find if the column is blank in Excel**. Let’s get started!!

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)

[![Conditional formatting column is blank](https://geekexcel.com/wp-content/uploads/2021/03/Conditional-formatting-column-is-blank.png)](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-for-if-column-is-blank/conditional-formatting-column-is-blank/#main)<figcaption id="caption-attachment-22411">Apply conditional formatting column is blank</figcaption>
## General Formula:

- You can use the below formula to highlight the cells when the column is blank.

**=[OR](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)(A1=””,B1=””, C1=””)**

## Syntax Explanations:

- **OR** – The [**OR Function**](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/) in Excel is a logical function to test multiple conditions at the same time.
- **A1, B1, C1** – These are the cells that contain input values.
- **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:

Let’s see the below example image.

- Here, we will give the input values in **Column B** to **Column D**. And we have calculated the sum from these inputs and return the result in **Column F**.
- Now we need to highlight the values in **Column F** based on the input range which contains blank values.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-13.png)<figcaption id="caption-attachment-22409">Input Ranges</figcaption>

- 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, we will get the results as per the below image.

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

## Wind-Up:

From this short tutorial, we have described how to apply the formula in the **conditional formatting option in Excel to format if the column is blank**. Let me know if you have any **doubts** regarding this article or any other **Excel/VBA** topic. Thank you for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Apply Conditional Formatting based on Another Column!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-column/)**
- **[Excel Formulas to Highlight 3 Smallest Values with Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-3-smallest-values-with-criteria/)**