5 replies
by shanghai sam
One way how it could be done is through Macros, i.e.:
1. Tools->Macro->Record New Macro, set a name and hot key.
2. Turn on AutoFilter
3. click on autofilter button in Start1 column and select (Custom...). Within opened window choose 'is less than' and type 'Today'.
4. Select the column and format font colour (Format->Font)
5. click again on Start1 autofilter button and select all.
6. choose Tools->Macro->Stop Recorder
That's all, only You shouldn't forget to change font color back to default one or You can add one more step -
2.a. click column's Start1 autofilter button, select the column and format a colour.
It works in MSP98, the same should be for the new one too.
Regards, Sergejs
by noelle
Why so complicated? Make a new filter for the action you want. [Project, Filters, More Filters, New, etc.] The only trick is first to make a field with a formula [Tools, customize, fields], e,g. Flag11 with: [Start1] < date()
Be sure that Start1 is filled. Perhaps, with Tracking, Save Baseline, Interim Plan or other techniques.
The filter, e.g. CheckLate would be: Flag11 equals yes
Copy the Entry or other Table e.g. as Late. [View, Table, More Tables] Apply and change colours. [Format, TextStyles]. Change next Highlighted Tasks to what you want, e.g. Red, Bold, 10 points.
Make a new view [View, More views], e.g. SeeLate. Make a new (single) view with table CheckLate, Gantt chart (if that is the one you are using], Filter Late and highlighted.
Save your project.
To use it everywhere use the organizer [Tools, Organizer]. Move (your new) Table CheckLate, Filter Late and View SeeLate to the global.mpt.
That is it without any VBA.
Good luck.
by noelle
by noelle
This discussion is closed to new replies.
Trending IT Employment posts
Sort by Trending