Searching for Lead time links & color coding them with a macro

[Val]

I have a macro that will color code the row blue, red, ...etc. However, I
can't figure out how to have the macro search each task for a negative lag
time (lead time) and then color code the row. I'd also like to search each
task for a non "FS" predecessor or successor link. My project files are
typically > 2000 lines and I'm getting tired of doing this by hand. After
color coding the rows, I plan on changing some of the SS and FF links to FS
because they are being used inappropriately.

Thanks in advance

 

[Andrew Lavinsky]

Why don't you just use a highlight filter?


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I have a macro that will color code the row blue, red, ...etc.
However, I can't figure out how to have the macro search each task for
a negative lag time (lead time) and then color code the row. I'd also
like to search each task for a non "FS" predecessor or successor link.
My project files are

typically>> 2000 lines and I'm getting tired of doing this by hand.
typically>> After
typically>>