conditional formatting help..

[ghrimm]

Hi,

I've been wrestling with a problem for a couple of days now. Here's
what I'm trying to do. I would like to italicize and set the color of
the row to purple when a condition on that row is satisfied (verifying
against custom field's data). Most of the code I've come across
requires a for..next loop. I'm trying to avoid this as I don't want
the code to go through every task everytime I change the condition of a
column. I would simply want it to evaluate the new data right on the
spot and change the the formatting of the row. Is this even possible
with MS Project? My Project file consists of smaller Project files
inserted into it. I would get errors about 'method not available in
this situation' if i try to use selecttaskfield or selectrow and I'm
also trying to code this within the ProjectBeforeTaskChange event. Any
help would be greatly appreciated. Thanks.

Francis

 

[Jan De Messemaeker]

Hi,

As a general remark, you better post this kind of questions in the
project.developer group
Still, have you thought of using the
activeselection.tasks(1)
way to identify your task?
HTH

 

[Francis]

Thanks, I'll move my question there.. I did think of that before, but I
couldn't figure out how to obtain the task ID properly. Since I have
inserted several project files into my main project file, the Task IDs
look like this now.

without expanding the summary lines...

1 Project 1
2
3 Project 2
4
5 Project 3

after expanding the summary lines..

1 Project 1
1 Subproject 1.1
2
3 Subproject 1.2
4
2
3 Project 2
1 Subproject 2.1
2
3 Subproject 2.2
4
4
5 Project 3
1 Subproject 3.1
2
3 Subproject 3.2

so I don't think the Task ID would be beneficial here..

 

[Jan De Messemaeker]

Hi Francis,

Who mentions task id?
activeselection.tasks(1) refers to the first (or the only) task in the
selection.
HTH