Automatic Alerts using Conditional Formatting in MS Project

Full Article / Information

"Automatic Alerts using Conditional Formatting in MS Project" By John Verth

Synopsis 

The article provides a demonstration of the use of Custom Fields within MS Project. The article shows how to create a custom date and a custom alert status indicator which are then used in combination to provide a visual indication of the current status of tasks.

Craig Coulson, Engineering Manager - Projects Expro North sea

Reference Type
Client/Customer

John is very well respected within the field of Project Planning and it was with this in mind that I brought him into the Project Engineering Team.  He seamlessly integrated himself within the team quickly establishing himself as a 'Go-To' inividual whose knowledge of the industry and specifically subsea operations was often sough and readily listened to.

John is a softly spoken individual that carries a lot of weight in what he has to say.  He has vast leadership qualities readily demonstrated by his ease in which he gets people's attention, understanding and approval.

Neil McLauchlan, Sales& Marketing Team Leader

Reference Type
Peer/Colleague

It is my opinion, that whilst operating within a project management function, the applicant will be regarded as the benchmarkfor professionalism in the discipline, and become the mobel for which others strive to emulate.

The appicant has a rare mix ofextensive experience and a well rounded 'tool kit', but importantly, also possesses a drive for continual improvement to ensure he remains match ready.

Andrew Macdonald, Project Group Leader

Reference Type
Direct Supervisor

I firmly believe John verth is an outstanding candidate for theGuild of Project Controls.  His knowledge, effort, ability and personality make him an asset to any group or team he should become involved with.

I consider myself vert fortunate, to have been able to call on John during my time in leading a project group, when on several occasions we were running in excess of 70 projects with only myself andy two other coordinators.

Fred Parker, Management Consultant. MD of Alba Venture Consulting Ltd

Reference Type
Direct Supervisor

A leader with a wealth of project experience in a variety of domains who is able to bring out the best in a team to ensure project success. Not afraid to challenge conventional methodology, his analytical mind creates solutions that he is able to articulate to his team & clients; and, get their endorsement. Although quietly spoken, his written and verbal communications skills are of the highest order and he has no difficulty in expressing his views or making sure his team does what he expects.

Kenneth Gray, Projects & Engineering Manager, Fugo-ImpROV Ltd

Reference Type
Direct Supervisor

I fully endorse John with respect to this application.  His knowledge is extremelly high and is professionalism is exemplary.

He is a highly motivated individual with high productivity and is a clear team player where he considers the big picture.  He is a natural leader with excellent abilities to coach, mentor and lead and has an excellent ability to deal with tricky situations and bring a resolution to a problem.  John deals in facts and is intuitive in resolving problems.