Conditional Formatting

[FXG]

Is there such a thing as Conditional Formatting in Project?
If anyone can tell me how to can change the font colour
for a task based on a value?
What I would like to do is set up values for different
font colours. I have a column to input these values in my
gantt chart.
So that each time I enter one of these values in the
column, it changes the task font to the corresponding
colour for that value. If there is no value in the column
for a task the font format, for that task remains
automatic.

Any help would be greatly appreciated.

FXG

 

[John]

I
FXG,
The closest thing Project has to conditional formatting is through
formulas in custom fields. However a task's font color is not one of the
available options when using a formula. Without using VBA the closest
you can come is to use Graphical Indicators with a custom field. There
are 11 color choices (plus no color) that can be set when the custom
field has a certain value. You can read more about how to use Graphical
Indicators in the help section.

However, you can get exactly what you want by using a VBA macro. The
macro can "read" the value in your custom field and then set the font
appropriately. If you have never used VBA, the best approach (short of
having someone write code for you) is to record a macro while you set a
task's font color. A little extrapolation of the resulting code will get
you what you want.

Hope this helps.
John

 

[Norman Sanin]

You can make a highlight feature of a filter that will color the items that
match the filter's conditions. Also, you can make Gannt bars reflect
certain conditions by changing the conditions where the bars appear. You
get to that by right clicking on the Gannt chart & selecting Bar Styles.

Sincerely,

Norman Sanin
Booz Allen Hamilton
8283 Greensboro Drive
McLean, VA 22102

(703) 377-0071
(e-mail address removed) <mailto:[email protected]>
AOL IM: Taipan Sanin