Change font color of late task

[Mercedes]

Is there a way to automatically (maybe a macro?) change the font color of
tasks that are not completed by due date?

 

[Gérard Ducouret]

Hello Mercedes

In the menu Format / Text Style, set a specific color for Marked Tasks
Then in the VBA Editor, paste the following macro:

Sub TacheRetard()
Dim oTache As Object
For Each oTache In ActiveProject.Tasks
If oTache.Status = 2 Then 'Retard
oTache.Marked = True
Else
oTache.Marked = False
End If
Next
End Sub

Gérard Ducouret

 

[MSPLearner]

Gérard,

Similarly, is there a way to set the font color based on a custom field
value; e.g Custom field has "Expense" or "Capital". Expense tasks = blue,
Capital tasks = Green?

MSPLearner

 

[Jan De Messemaeker]

Hi,

Not through formulas I'm afraid.
You can build a custoom filter and use "highlight filterd tasks" together
ith a coloring of the highlighted tasks, or you cna go through a VBA
procedure.
HTH