Forum Discussion
Multiple conditions task color coding
Hi,
I'm a newbie on MS Project so sorry if this question is trivial!
I'd like to color code my tasks based on the resources. I've found multiple ways to do that with on the web but it only applies when you have a single resource per task.
For my application I'd like to color code the task based on the machine used but I also have to add an operator as a second resource. I'm pretty sure there should be a way to code this in the custome fields but I have not mangaed to find it so far.
Anyone could help me out?
THX!
6 Replies
That can probably be done with a carefully crafted custom field formula but we'll need more information. 1. What version of Project are you using?
2. It sounds like you only want the color coding for machine (work) resources, is that correct?
3. What exactly do you want to color code, the task font, the Gantt bar, or what?
4. How are your machine resources identified (e.g. name)?
Screen shots of your Gantt Chart and your Resource Sheet would be very helpful.
John
Hi John-project,
Thx for your quick feedback! 🙂
1-Client de bureau Microsoft® Project® Online MSO (Version 2407 Build 16.0.17830.20056) 64 bits
2- yes but I usually have both a machine and an operator which seems to be throwing off my conditions
3- Task bar in Gantt at this point would be nice
4- see print screens (resources 1-7 are machines and 8-24 are people)
If you have only the 7 machines (i.e. less than 15), then you might try a Switch statement that sets Flag1 for any Resource Names field that contains one the 7 machine names (or machine initials per the Resource Initials field). The format a Gantt Bar style to queue on the Flag1 field. As I recall a Switch statement can only handle up to 15 arguments.
A VBA solution could also be used. It would provide greater flexibility (i.e. unlimited machine resources).
John
