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 changed in the timeline section.
For example, as shown in the attachent, when i change the status for the start date - end date range 25-Jun-21 - 06-Jul-21, the corresponding date cells in the timeline portion should change to a different color.

Hope someone can help me out.

Formulas and Functions

6 Replies

    • 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