Forum Discussion

Vaibhav002's avatar
Vaibhav002
Copper Contributor
Mar 09, 2023

Looking to create a gantt chart in excel basis a start and end date range

Hi,

 

I have a work plan to create for which I have the activities listed in rows while the date range (start and end date against it). I want to basically colour code the cells basis the data range.

 

I have attached a sample input vs output in the file.Please help me with this.

 

Thanks!

excel
Formulas and Functions

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 09, 2023

    Vaibhav002 

    Select I5:T6. I5 should be the active cell in the selection.

    On the Home tab of the ribbon, click Conditional Formatting > New Rule...
    Select 'Use a formula to determine which cells to format'.
    Enter the formula

     

    =AND(I$4>=$E5,I$4<=$F5)

     

    Click Format...
    Activate the Fill tab.
    Select a highlight color.
    Click OK, then click OK again.

     

    See the attached version.

Resources