Forum Discussion
Multiple conditions task color coding
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
HeyJohn-project
Thanks again for your support.
I'll give the switch function a try then.
Have a good one
Thibault
