The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » microsoft project training seminar - Splitting the colour of the bar with a formula - for days over t

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

microsoft project training seminar - Splitting the colour of the bar with a formula - for days over t

Resolved · Low Priority · Version Standard

ReplyFri 1 Dec 2006, 08:43Delegate Refiya said...

Splitting the colour of the bar with a formula - for days over t

During our course on the 2nd day. Garry had shown us a formula to use to highlight the days over with colour coding through a formula. I have forgotton to send the file to myself. Would it be possible for him to provide this file or some other file with the formula and instructions Please?

For upcoming training course dates see: Pricing & availability

ReplyTue 5 Dec 2006, 09:02Trainer Andrew said...

RE: splitting the colour of the bar with a formula - for days ov

Hi Refiya

thanks for your message - we'll check the code and post to you.

Andrew

ReplyMon 18 Dec 2006, 15:38Trainer Andrew said...

RE: splitting the colour of the bar with a formula - for days ov

Hi Refiya

I now have the example file and will email it to you today.

If you have further questions please do let us know.

Kind regards,

Andrew

MS Project articles

· Defining a Project's Success
· Microsoft Project Training Courses
· Avoiding Project Failures
· Microsoft Project Helps You Lose The Jargon
· Seeing The Bigger Picture: Enterprise Project Management With MS Project

Ms project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips

How can I tell if my colleague has made changes on a shared document, and where? thanks.

» Forum post: Tracking changes in worksheets

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions