Thursday, September 11, 2008

Gantt Chart Task Bar Conditional Formatting

Suppose your boss has requested that the task bars on your Microsoft Project Gantt chart be Green if they haven’t started or when they are in progress, but Red if they are late.

  1. In the Task window, right click on a column heading and select Insert Column…
  2. Select Flag 1 from the Field Name drop down and then click OK
  3. Right click on Flag 1 column heading and select Customized Fields…
  4. Select Flag 1 from the list and click the Rename button
  5. Enter Overdue Task and click OK
  6. Click the Formula… button
  7. Copy this formula into the space provided:
    IIf(Now()>[Finish] And [Actual Finish]=ProjDatevalue("NA"),Yes,No)
  8. Click the OK button
  9. Select Format > Bar Styles…
  10. Select the Task line and change the Color to Green
  11. While the Task line is selected, click the Cut Row button immediately followed by clicking the Paste Row button two times
  12. Rename the second Task line to Task – Red
  13. Select the Task – Red line and change the Color to Red
  14. On the Task – Red line, click in the Show For … Tasks column and change the value to Flag 1
  15. Click the OK button

No comments:

Paychecks: an Exchange of Value for Value

Having managed and supervised people for many years now, it is evident to me that the concept of "value for value" is not clearly ...