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

[arunnairs]

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.

[#2]

@arunnairs 

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

[#3]

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

[#4]

@arunnairs 

See the attached version.

[#5]

Thank you Hans !! This is what i wanted.

Could you please tell the formula or condition used?

Regards
Arun

[#6]

@arunnairs 

Click in cell K5.

On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...

You'll see rules for green, yellow and red.

Select one of these rules and click Edit... to see the formula I used.

[#7]

Thank you!