Hey everyone,
i recreated the Project Management Dashboard from the Video Mynda made on Youtube.
I just wanted to know, if its possible to change the color of the time bars based on the Project. Like individuell color for each project.
I am looking forward to read your reply.
Hi Sebahattin,
Yes, you can add more conditional formats (one for each project) that colours the cells, but if you have a lot of projects, then it's a lot of work!
If you get stuck, please share your file here and we can see where you've gone wrong and help further.
Mynda
Hi Mynda,
here is the file i am working with. It's in german, but Project is equal to Maschine, Startzeit = Start Time, Endzeit = End Time.
I hope you can handle it with german 😀
Sebahattin
Hi Sebhattin,
Using the example in your file, if you wanted the time bars for Angelini Drehbank coloured purple, you'd use this formula in your conditional format:
=AND(J$9>=$F10,WORKDAY($F10,$H10,1)-1>=J$9,$A10="Angelini Drehbank")
For this to work, you have to repeat row labels for the Maschine field in the PivotTable (right-click the field in the PivotTable > Field Settings > Layout & Print tab > 'Repeat item lables'.
And then you'd need to create new conditional formatting rules for each Maschine name and associated colour.
Mynda
