Automatic bar colours
Forum Sponsor
Top Posters
Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 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