Forum Discussion
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...
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
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
See the attached version.
- Thank you Hans !! This is what i wanted.
Could you please tell the formula or condition used?
Regards
ArunClick 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.
- Thank you!