Automatic bar colours

I am fairly certain it is not an inbuilt function but you could try writing a macro to format both at the same time.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au

Paul is right, you cannot link colors of bars and text; the only way would be a macro
Alexandre

Thanks Gents,

Any assistance would be very much appreciated

You can do this by using a flag field (say flag1), with a formula assigned.

The formula needs to identify your keyword within the name field using an iif() funtion, so if it is in a fixed position, thats more helpful.

Then in the Bar Styles dialog, create your alternative bar style, and add ’normal, flag1’. Also add ’Not Flag1’ to the default bar / task bar.

Flag1 will then change to Yes if the word is detected or no if not and the bar style will be determined by the formula automatically.

What I tend to do rather than detect a keyword is to have a text field with an assigned value list. I just choose the value, in your case ’design’, and the bar changes to suit.

This allows you to use the text field as a code and extend the functionality of the built-in grouping functions also.

HTH,
Jon.