Special Formatting to values in Project 07

[Mike]

Hi all,

I'm curious if there's a way to format individual cells in Project
2007 based upon values? For example, I'm doing a calculation in a
custom field that shows me the variance difference in last week's
remaining work and this week's remaining work. If the variance
difference is zero, then I really don't care to pay attention. If the
variance is > 1 but < 8 hours, I'd like to highlight the cell
background yellow. While if the variance is > 8 hours, then it needs
to be red.

As close as I've seen is the "text styles" where I could highlight
based on "cell changes". Where a cell would be highlighted if it has
changed... but this has serious (if not obvious) limitations.

Any input is welcome!

Kind regards,
Mike

 

[Dale Howard [MVP]]

Mike --

Microsoft Project 2007 does not offer conditional formatting, such as what
you find in Excel. Sorry.

 

[Mike Glen]

Hi Mike,

Welcome to this Microsoft Project newsgroup

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #15 on customizing and using graphical
indicators, 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 article 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

 

[Mike]

Mike,

This article is exactly what I was seeking. I haven't applied it to
our projects yet, but the article you linked appears quite thorough
and informative. I'll rate it after I apply it to my projects, but
thank you in advance!

Kind regards,
Mike

 

[Mike Glen]

You're welcome, Mike, and thanks for the feedback.

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