auto highlighting tasks for coming week

[Lynn]

How can i program MS project to auto highlight tasks for coming week?

 

[Dave]

How can i program MS project to auto highlight tasks for coming week?

This can be done. Look at the following link to see how to do it for
tasks using a particular resource:

http://project.mvps.org/faqs.htm#Customizing Task Bars - Project 2000

Now you just have to change the definition in Flag1 so that it
highlights those tasks that are in progress or which are starting in the
next week.

 

[Lynn]

This can be done.  Look at the following link to see how to do it for
tasks using a particular resource:

http://project.mvps.org/faqs.htm#Customizing Task Bars - Proj...

Now you just have to change the definition in Flag1 so that it
highlights those tasks that are in progress or which are starting in the
next week.

I can't figure out which 1 to look for in the link provided. There are
51 FAQs.......
could you tell me? thanks

 

[Lynn]

This can be done.  Look at the following link to see how to do it for
tasks using a particular resource:

http://project.mvps.org/faqs.htm#Customizing Task Bars - Proj...

Now you just have to change the definition in Flag1 so that it
highlights those tasks that are in progress or which are starting in the
next week.

i managed to find it. But what is the formula for highlighting tasks
for next week?

 

[Dave]

i managed to find it. But what is the formula for highlighting tasks
for next week?

It depends partly how you maintain your plan. However if you define a
task next week as:

"A task whose start days before today's date plus 5 and which hasn't
finished" then something like:

Iif( ( [Finish] > [Current Date] ) AND ( [Start] < ProjDateAdd( [Current
Date] , "5D" , "Standard" ) ) , Yes , No )

You might have to experiment with making the ">" ">=" and the "<" "<="
if this doesn't quite map to the right days.

This should flag those tasks in-progress at some point over the next 5
calendar days (it won't take account of split tasks). If you want to
show exactly the tasks for a given calendar week, then you will have to
replace [Current Date] with [Status Date] and manually set the status
date (Project/Project Information).

Actually, having done this, you can filter on the Flag1 field to only
show the tasks for the next week without going to the trouble of
colouring the tasks if that is good enough for your purposes.

 

[Mike Glen]

Hi Lynn,

Welcome to this Microsoft Project newsgroup

This seems an unnecessary step. Why not just zoom in so that only next week
is showing? Or use a filter with a date range set for that week?

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Lynn]

Hi Lynn,

Welcome to this Microsoft Project newsgroup

This seems an unnecessary step.  Why not just zoom in so that only nextweek
is showing?  Or use a filter with a date range set for that week?

FAQs, companion products and other useful Project information can be seenat
this web address:http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
Seehttp://tinyurl.com/2xbhcfor my free Project Tutorials






- Show quoted text -

thanks for introducing filter. it works. however, it would be nice if
MSP can automatically highlight those task that are going to start
next week.

 

[Projectability]

Lynn,

If you have a filter that will deliver the required results you could look
at creating a new view, "This Weeks Tasks" that incorporates the filter that
works but highlights the tasks rather than excludes the tasks that do not
comply with the conditions of the filter - if you want to really emphasise
the tasks you could edit the highlight text style for the view as well to
include contrasting font, cell colour and shading. If you tick the "show in
menu" option the view will be available from the View Menu and also on the
View Bar displayed on the left hand side of the screen.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

www.projectability.co.uk

Hi Lynn,

Welcome to this Microsoft Project newsgroup

This seems an unnecessary step. Why not just zoom in so that only next
week
is showing? Or use a filter with a date range set for that week?

FAQs, companion products and other useful Project information can be seen
at
this web address:http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
Seehttp://tinyurl.com/2xbhcfor my free Project Tutorials






- Show quoted text -

thanks for introducing filter. it works. however, it would be nice if
MSP can automatically highlight those task that are going to start
next week.

 

[Lynn]

Lynn,

If you have a filter that will deliver the required results you could look
at creating a new view, "This Weeks Tasks" that incorporates the filter that
works but highlights the tasks rather than excludes the tasks that do not
comply with the conditions of the filter - if you want to really emphasise
the tasks you could edit the highlight text style for the view as well to
include contrasting font, cell colour and shading. If you tick the "show in
menu" option the view will be available from the View Menu and also on the
View Bar displayed on the left hand side of the screen.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

www.projectability.co.uk











thanks for introducing filter. it works. however, it would be nice if
MSP can automatically highlight those task that are going to start
next week.- Hide quoted text -

- Show quoted text -

excellent!

 

[Mike Glen]

You're welcome, Lynn

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #21 et seq, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

Hi Lynn,

Welcome to this Microsoft Project newsgroup

This seems an unnecessary step. Why not just zoom in so that only next
week
is showing? Or use a filter with a date range set for that week?

FAQs, companion products and other useful Project information can be seen
at
this web address:http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
Seehttp://tinyurl.com/2xbhcfor my free Project Tutorials






- Show quoted text -

thanks for introducing filter. it works. however, it would be nice if
MSP can automatically highlight those task that are going to start
next week.

 

[jblack]

Try this article (with screenshots):
COLOR CODING TASKS BASED UPON DATE RANGE
http://www.pmconnection.com/modules.php?name=News&file=article&sid=6

 

[Dave]

Lynn,

If you have a filter that will deliver the required results you could look
at creating a new view, "This Weeks Tasks" that incorporates the filter that
works but highlights the tasks rather than excludes the tasks that do not
comply with the conditions of the filter - if you want to really emphasise
the tasks you could edit the highlight text style for the view as well to
include contrasting font, cell colour and shading. If you tick the "show in
menu" option the view will be available from the View Menu and also on the
View Bar displayed on the left hand side of the screen.

You could also record a macro of you colouring all the tasks in the
filtered view and then removing the filter. That would allow you to
colour tasks starting next week.

Did the formula presented elsewhere in this thread not work?