Changing Bar Colour

S

sarah

I am currently using this formula and linking this with the graphic indicator
to creative a trafic light system.

IIf([Baseline Start]>999999,"No Baseline",Switch(([Finish]-[Baseline
Finish])<=0,"On Schedule",([Finish]-[Baseline Finish])<=10,"1-10d
Late",([Finish]-[Baseline Finish])>10,">10d Late"))

Graphic indicator eg If "On Schedule" = green light

Is there anyway to link the trafic light so that when the task is on
schedule, the bar will be green and when it is "1-10d Late" the bar turns
yellow, etc??

Please advise
 
M

Mike Glen

Hi Sarah,

Welcome to this Microsoft Project newsgroup :)

You might like to see FAQ Item: 31 on customizing task bars. FAQs, companion
products and other useful Project information can be seen at this web
address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on :)

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top