Ghantt task bar colors for specific resources.

[Dkirkpat]

I searched and found out how to do this using flags. My problem is that if any other resource is assigned it ignores my flag color choice and goes to the default color. I have several critical and high cost resources that must be highlighted on the printed out ghantt.

Thanks for any help.

 

[SkipVought]

Hi,

Write a query that produces numeric columns (series) that correspond to the number of colors you need to display. Each bar's numeric value will appear in ONE of the numeric columns (series); the one that you select in you logic.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JulieInMaine]

Dkirkpat,

What test are you using in your formula? I assume you are using the Flag fields?

Julie

 

[Dkirkpat]

[Resource Names]="NDI" for flag1. It works perfectly if the only resource is NDI.

I used this post to set it up.

http://www.tek-tips.com/viewthread.cfm?qid=591102

 

[JulieInMaine]

Hello Dkirkpat,

Try the following instead:

IIf(Instr([Resource Names], "NDI")>0, -1, 0)

The Instr function check the position of the "NDI" task in the Resource Name field. If the "NDI" string exists anywhere within the Resource Names field, the value will be greater than 0.

So, this should work if "NDI" is the only resource assigned or one of many.

I hope this helps.

Julie

 

[Dkirkpat]

Thanks!

 

[JulieInMaine]

You're most welcome!

Julie