Excel Formulas to Highlight the Missing Values ~ Easy Tutorial!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-31 04:03:21

---
title: Excel Formulas to Highlight the Missing Values ~ Easy Tutorial!!
published: true
date: 2021-03-30 10:10:41 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-the-missing-values-easy-tutorial/
---

For example, we have two lists of data in a worksheet, and now we need to compare these two lists and **highlight the missing values in Excel**. It may be not easy to solve it manually. In this article, I will introduce some tricky tips to solve it easily. 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 missing values](https://geekexcel.com/wp-content/uploads/2021/03/Highlight-missing-values.png)](https://geekexcel.com/excel-formulas-to-highlight-the-missing-values-easy-tutorial/highlight-missing-values/#main)<figcaption id="caption-attachment-22751">Highlight missing values</figcaption

## General Formula:

- You can use the below formula to highlight the missing values in Excel.

**=[COUNTIF](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)(list,A1)=0**

## Syntax Explanations:

- **COUNTIF** – In Excel, the **[COUNTIF function](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)** will help to count the number of cells that meet a single condition or criteria.
- **List** – It specifies the input range.
- **A1** – It represents the input values from your worksheet.
- **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 show how to highlight the missing values.

- First, we will enter the input values in **Column B** and **Column D**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-40.png)<figcaption id="caption-attachment-22748">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, it will highlight the result and displayed it as shown below.

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

## Wrap-Up:

In this article, we have discussed the simple formula used to **highlight the missing values in Excel**. If you have any issue regarding this article or any **unresolved query** , please comment in the **comment** box below. We will assist you. 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 Also:

- **[Excel Formulas to Highlight Duplicate Rows ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-duplicate-rows/)**
- **[Excel Formulas to Apply Conditional formatting Dates Overlap!!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-dates-overlap/)**