Conditional formatting task usage view

[JOPX]

I want to have conditional formatting in my MS Project file (Project 2003).
Whenever actual work > baseline work I want to display the line in red, is
this possible?

friendly greetings,

Joris

 

[John]

I want to have conditional formatting in my MS Project file (Project 2003).
Whenever actual work > baseline work I want to display the line in red, is
this possible?

friendly greetings,

Joris

Joris,
What exactly do you mean by, "...display the line in red..."? If you are
referring individual lines of tabular data on the left side of the view
(e.g. Task Name, Work, etc.) you can creating a highlighting filter. On
the other hand, if you are referring to the timphased data on the right
side of the view, individual lines cannot be highlighted. The background
color can be changed, but it will apply to all task cells.

Now, my compadres will probably shake their heads at me for making this
next suggestion, but you could use VBA to export the Task Usage view
data to Excel where any row or cell can be highlighted as desired.

Hope this helps.
John
Project MVP

 

[JulieS]

Hi Joris,

Do you want the bar in the Gantt chart to turn red?

If so, you could use a Flag field (Flag1 for example) to test whether Actual
Work is greater than Baseline Work and set the Flag to "Yes". Then using the
Format>Barstyles command, create a new Gantt bar where the bar only displays
for Flag1 tasks.

See FAQ 31. "Customizing Task Bars - Project 2000" at:
http://www.mvps.org/project/faqs.htm

for some suggestions on working with custom fields. The FAQ references
Project 2000, but it works the same in later releases as well. You will want
to modify the formula referenced in the first paragraph to something like:
IIf([Actual Work]>[Baseline Work] Or [Actual Work]+[Remaining
Work]>[Baseline Work],1,0)

The formula above sets the Flag to yes if either actual work is greater than
baseline or the combination of actual and remaining work is greater than
baseline.

Hope this helps. Let us know how you get along.

Julie

 

[JulieS]

OOOPS.

A thousand pardons. I neglected to read the subject line closely enough......

Julie