Excel Formulas to Apply Conditional formatting Dates Overlap!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-19 03:58:46

---
title: Excel Formulas to Apply Conditional formatting Dates Overlap!!
published: true
date: 2021-03-18 11:24:41 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-dates-overlap/
---

 **Conditional formatting** is a fantastic way to quickly visualize the data in a spreadsheet. In this tutorial, we are going to **apply the formula in the conditional formatting option to format cells where the dates overlap**. 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)

[![Conditional formatting where dates overlap](https://geekexcel.com/wp-content/uploads/2021/03/Conditonal-formatting-where-dates-overlap.png)](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-dates-overlap/conditonal-formatting-where-dates-overlap/#main)<figcaption id="caption-attachment-22434">Conditional formatting where dates overlap</figcaption>
## General Formula:

- Use the below formula to highlight the cells where dates overlap in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)((start\_date<=end\_dates)\*end\_date>=start\_dates))>1**

## Syntax Explanations:

- **SUMPRODUCT** – This function multiplies the corresponding arrays or ranges and returns the sum of the products. Read more on the [**SUMPRODUCT function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **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 D**.

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

- Then enter the formula into the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section. It will display the result as per the below image.

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

- Now apply the same 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 below.

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

## Wind-Up:

Hope you like this article on how to apply **conditional formatting to find where the dates overlap in Excel**. Let me know your **queries** about this article. Please feel free to share it with us. 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 Highlight 3 Smallest Values with Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-3-smallest-values-with-criteria/)**
- **[Excel Formulas to Apply Conditional Formatting based on Another Column!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-column/)**
- **[Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!](https://geekexcel.com/calculate-cell-values-based-on-font-background-or-conditional-color-in-excel-365/)**