Highlighting Certain Information

[vidamj]

I have created my own view within Project Server which also uses a Macro to do a function. The next step is to highlight information using a different font color. Say if the number of work is greater than 10 hours I want the font or background of that line to change to Red. Is this possible. Any solutions on how to highlight this information would be greatly appreciated.

 

[PDQBach]

I don't have P2000 on this machine but I don't think you can change the background colour.

For the font colour, some VBA code like this should work

Sub jb3()
Dim tt As Task
SelectSheet
OutlineShowAllTasks

For Each tt In ActiveProject.Tasks
If Not tt Is Nothing Then
If tt.Work > 60*8*10 Then
iID = tt.ID
SelectRow row:=iID, rowrelative:=False
Font Color:=pjRed
End If
End If
Next
End Sub


60 minutes in a hour
8 hours in a day
10 days was the number of days you specified.

 

[billnorr]

You cannot change the background (cell) color in a MSProject table. There are other options, however, such as font colors, Gantt bar colors, and graphical indicators.

Good Luck!

Bill
----------
Got MSProject Questions?
Visit

http://www.DiscussMSP.com

Real-Time Help for Microsoft Project
----------