Automatic bar colours
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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.
Thanks Gents,
Any assistance would be very much appreciated
Paul is right, you cannot link colors of bars and text; the only way would be a macro
Alexandre
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