Excel Formulas to build a Gantt Chart with Conditional Formatting!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-17 09:14:48

---
title: Excel Formulas to build a Gantt Chart with Conditional Formatting!!
published: true
date: 2021-03-16 11:47:32 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-build-a-gantt-chart-conditional-formatting/
---

A Gantt chart is a **type of bar chart** that is mainly used for **project management** like planning, scheduling, and so on. Have you ever tried to create a Gantt chart with a conditional formatting option in Excel? In this tutorial, we are going to show how to **build a Gantt chart in Excel by using conditional formatting**. 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)

[![Gantt chart](https://geekexcel.com/wp-content/uploads/2021/03/Gantt-chart.png)](https://geekexcel.com/?attachment_id=22490#main)<figcaption id="caption-attachment-22490">Gantt chart</figcaption>
## General Formula:

- You can use the below formula to create a Gantt chart with conditional formatting.

**=[AND](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)(date>=start,date<=end)**

## Syntax Explanations:

- **AND** – This Function checks Multiple Conditions and returns [**TRUE **](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)if all the conditions are evaluated as true otherwise returns **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)**. Read more on the **[AND function](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)**.
- **Date** – It represents the input value.
- **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.

- Here, we have a start date and end date in **Column B** and **Column C**.
- From these input data, we need to create the Gantt chart in **Column D** to **Column R**.

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

- So apply the above-given formula to 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 cells based on our input and display the result as per the below image.

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

## Closure:

From this short tutorial, we have described **how to create a Gantt chart by using the Conditional Formatting option in Excel**. Hope you like it. If you have any other **queries** regarding this article, don’t forget to let me know. I reply to **queries** frequently. To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[How to Create a Gantt Chart with Several Clicks in Excel?](https://geekexcel.com/how-to-create-a-gantt-chart-with-several-clicks-in-excel/)**
- **[Excel Formulas to Apply Conditional Formatting Based on Past Due Dates!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-past-due-dates/)**