Colour task bar by Task Name text

[FionaDM]

I'm running Project 2007. I would like to be able to set the colour of
certain task bars depending on text appearing in the Task Name. E.g. Say I'm
working on a Building Construction project and I want all tasks bars with the
work 'Tender' ore 'tender' in the Task Name to be coloured red and all task
bars with 'Construction' in the Task Name to be coloured green.

I assume this requires some programming on my part to grep these string but
where would I start?

Any references or example would be appreciated.
FionaDM

 

[Jan De Messemaeker]

Hi Fiona,

It's a bit long to explain but it's not that difficult.

1. Format, Bar Styles (one example)
At the end of the list add a line
Name ... Tender Tasks
Appearance ... select what you want to show
Show For... Flag1

2. Insert Flag1 field, select.
Tools, Customize, Fields
Flag1 is selected
Click the word "Formula"
Enter a formula as follows
Iif(Instr([Name],"tender")>0,Yes,No)
OK, etc.

Tat's it for >Tender.
Now again for Flag2 and Construction, etcetera.

Hope this helps



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf