Log In
Register
Home
Active Member
January 24, 2023
Offline
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.
July 16, 2010
Offline
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
Active Member
January 24, 2023
Offline
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
July 16, 2010
Offline
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
1 Guest(s)
