Special Offer: Buy 1 course, get 2nd free! Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!
Course Of The Month
6 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Project 2010 - how to color resources in different colors?
Posted on 2012-12-24
MS Project 2010 - how to color resources in different colors?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
Hi longjumps are you looking to color task bars with resources assigned to them? The concept can be adapted to suit resources.
Conditionally formatting bar styles in Project 2010
...Terry
Conditionally formatting bar styles in Project 2010
...Terry
In the "Resource Form Tools" table, I don't see "Appearance" like in the example with Task Bar.
Using such "Appearance" they color bars.
But how could I color Resources?
Attached.
MPP-question-color-resource.png
Using such "Appearance" they color bars.
But how could I color Resources?
Attached.
MPP-question-color-resource.png
Sorry it doesn't have that functionality built in for resources unfortunately, which is a shame. You need to work through that complex Flag workaround I sent you before, or use the VBA routine to color them.
Steps:
1. Make sure each of your resources have distinct names or initials. We use full names at our organization. Important to note that you can only colour code up to 20 resources. If you're looking for more you're out of luck. It would be hard anyways as eventually many colours start to look the same on your monitor.
2.Right click on any column.
3. Select Custom Fields
4. Type: Select Flags (it has to be flags) Please note important to keep it on Tasks and not Resources as you're changing the appearance of a task on the gantt chart.
5. Rename each flag to the Resource name exactly as you have it on your resource list.
6. Under custom attributes select formula
7. Create formula in the box as "the name of the resource as entered" = {Resource Name} Note: I used the insert field -> text -> resource name rather than typing in as it didn't work when typing in for me.
8. select okay
9. Under Format choose Format -> Bar Styles
10. Scroll down to the bottom to enter information rather than selecting insert row at the top. For me if I did it at the top it didn't work and all bars would change colour. Make sure to scroll down.
11. Name Field enter the resource name as entered in the system
12. Appearance Field choose the colour you want. Do not hit okay make sure you do the next step or you'll also have an error.
13. Show For Tasks: Enter the Flag# that you changed names.
Please note, the flag number and resource name must be the same as what you did steps 1 through 6.
Note that if you have n a US English installation some of the field delimiters may be different. The formula in step 7 should not have braces around "Resource Name" and the field name is Resource Names, not Resource Name. The formula should be:
"Name of Resource" = [Resource Name]
Also, note that this formula only works if the resource is the only one assigned.
You might find the following formula works a bit better:
IIf(Instr([Resource Names],"Name of Resource")>0,"Yes")
This formula will search the [Resource Names] field and if the "Name of the Resource" appears anywhere in the string, it will return the position of the string. If the resource's name is in the list, the value should be greater than zero.
Hope this helps!
1. Make sure each of your resources have distinct names or initials. We use full names at our organization. Important to note that you can only colour code up to 20 resources. If you're looking for more you're out of luck. It would be hard anyways as eventually many colours start to look the same on your monitor.
2.Right click on any column.
3. Select Custom Fields
4. Type: Select Flags (it has to be flags) Please note important to keep it on Tasks and not Resources as you're changing the appearance of a task on the gantt chart.
5. Rename each flag to the Resource name exactly as you have it on your resource list.
6. Under custom attributes select formula
7. Create formula in the box as "the name of the resource as entered" = {Resource Name} Note: I used the insert field -> text -> resource name rather than typing in as it didn't work when typing in for me.
8. select okay
9. Under Format choose Format -> Bar Styles
10. Scroll down to the bottom to enter information rather than selecting insert row at the top. For me if I did it at the top it didn't work and all bars would change colour. Make sure to scroll down.
11. Name Field enter the resource name as entered in the system
12. Appearance Field choose the colour you want. Do not hit okay make sure you do the next step or you'll also have an error.
13. Show For Tasks: Enter the Flag# that you changed names.
Please note, the flag number and resource name must be the same as what you did steps 1 through 6.
Note that if you have n a US English installation some of the field delimiters may be different. The formula in step 7 should not have braces around "Resource Name" and the field name is Resource Names, not Resource Name. The formula should be:
"Name of Resource" = [Resource Name]
Also, note that this formula only works if the resource is the only one assigned.
You might find the following formula works a bit better:
IIf(Instr([Resource Names],"Name of Resource")>0,"Yes")
This formula will search the [Resource Names] field and if the "Name of the Resource" appears anywhere in the string, it will return the position of the string. If the resource's name is in the list, the value should be greater than zero.
Hope this helps!
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Office 365 list of users and their count of sent items | 3 | 37 | |
| Macro Modification to refresh non-contiguous Cells in a Worksheet | 12 | 38 | |
| Jira: Viewing all issues viewed in the last week | 3 | 19 | |
| count values within multiple bands | 7 | 34 |
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses
Course of the Month6 days, 19 hours left to enroll
732 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.