Forum Discussion

arunnairs's avatar
arunnairs
Copper Contributor
Mar 29, 2022

In Gantt timeline, change date cell color when status changes for that date range

I have a Gantt chart project plan with fields Start Date, End Date & Status (To Do, In Progress & Done). Whenever i change the status, i need the colour of the selected date range cells to be change...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Mar 29, 2022

arunnairs 

Please attach a small sample workbook, or make it available through OneDrive, Google Drive, Dropbox or similar.

  • arunnairs's avatar
    arunnairs
    Copper Contributor
    Mar 29, 2022
    As of now, depending on the start date and end date selection, the date cells in timeline portion gets filled with a color. (Currently violet is given)

    The status column has 3 values namely To Do, In Progress and Done.
    Whenever I change the status, i need the color of the timeline cells corresponding to the start date & end date should change.
    Colors can be chosen as follows:
    To Do - Red
    In Progress - Yellow
    Done - Green.

    Hope this makes sense.


    https://1drv.ms/x/s!AuCot5kQYYNji291AKYoVnt__Grc?e=g2wac2

Resources