Hi, I am working with MS Project 2003 and I would like to know if we are able to color a cell background when task meets some condition. Ex: if my task is completed and Finish date happened more than 10 days ago then color a task row to red... Thanks in advance..
Project 2003 can't color backgrounds, but 2007 can. However to get conditional formatting that you want, you would need a macro to set the Marked field for Tasks that match your criteria, then have the text Style for Marked be what you want. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com wrote in message news:58ee9bf7-53f8-4694-b601-322f3c8c8a53@z72g2000hsb.googlegroups.com... > Hi, > > I am working with MS Project 2003 and I would like to know if we are > able to color a cell background when task meets some condition. Ex: if > my task is completed and Finish date happened more than 10 days ago > then color a task row to red... > > Thanks in advance.. >
