Discussion Locked

MS Project Date Fields - highlight text

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I currently have a MSProject 2000 file set up for several users, in which each user has to go in and update their dates. What I would like is that if the date in column (ie Start1 column) is prior to Today, the colour of the text for that field changes to red. Does anyone know if this is possible and if so, how?

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 kees.valkenswaard

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.

This discussion is closed to new replies.