Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-14-2017, 05:26 PM
Guloluseus Guloluseus is offline Highlighting task before start date Windows 7 64bit Highlighting task before start date Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Custom columns will do this. I will assume you donr know how to do these, so the easy steps are:
1. Insert anew column in project, select "number 1" (assuming its not already in use)- doesnt matter which as long as its a number column.
2. right click on the field heading and select "custom fields".
3,. Click on the button that says "formula" and paste the following into the big box at the top
IIf([% Complete]>0,1000,IIf([Start]<[Current Date]-7,3,IIf([Start]<[Current Date],2,IIf([Start]<[Current Date]+7,1,1000))))

4. Go down to "graphical indicators" at the bottom, and fill it in as in the attached piccy.
5. close all windows by clicking OK.

This will give you a visual indicator of a red flag if a task should have started more than 7 days ago, a red dot if it should have started between 7 days ago and now, and an amber indicator if its due to start in the next 7 days. anything else shows as green.

this works by comparing the expected start date to TODAYS date (so that will be the date you open the programme, so if its the 22nd nov when you look at it that will be the date compared to. If there si any progress logged (ie % complete is 1or more %, then the task will be green (progress has been made), if no progress has been logged and it should have started then it will have an indicator.

If this isnt what you needed or you have probs, post back and we see if we can make a better formula for you.
Attached Images
File Type: jpg qqq.JPG (81.9 KB, 16 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlighting task before start date Showing a Task Start Date Slip Pmacdaddy Project 1 01-26-2017 10:14 AM
Set start and end dates of one task based on one other task only zamshabeer Project 1 07-07-2016 11:25 AM
Highlighting task before start date Start date of successor task does not change raminraiszadeh Project 3 09-19-2015 01:41 PM
How to make a task adjust its end date depending on another task? (Newbie) ravl13 Project 3 07-27-2014 06:10 PM
Task with Start date but no Due date? bplat Outlook 0 01-12-2012 08:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft