Special Formatting to values in Project 07

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
Thu Apr 17 16:30:54 CDT 2008

Mike --

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

--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Mike" <michaeldholcomb@gmail.com> wrote in message
news:8c9183bc-4323-4db6-aee8-c1e9a7887f6f@p25g2000hsf.googlegroups.com...
> 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

Mike
Thu Apr 17 16:45:04 CDT 2008

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 wrote:
> 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

Mike
Mon Apr 21 09:56:48 CDT 2008

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


On Apr 17, 5:45=A0pm, "Mike Glen" <glenATmvps.org> wrote:
> 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=A0or this:http://pubs.lo=
gicalexpressions.com/Pub0009/LPMFrame.asp?CMD=3DArticleSe...
> (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
>
>
>
> =A0Mike wrote:
> > Hi all,
>
> > I'm curious if there's a way to format individual cells in Project
> > 2007 based upon values? =A0For 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. =A0If the variance
> > difference is zero, then I really don't care to pay attention. =A0If the=

> > variance is > 1 but < 8 hours, I'd like to highlight the cell
> > background yellow. =A0While 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". =A0Where a cell would be highlighted if it has
> > changed... but this has serious (if not obvious) limitations.
>
> > Any input is welcome!
>
> > Kind regards,
> > Mike- Hide quoted text -
>
> - Show quoted text -

Mike
Mon Apr 21 10:59:45 CDT 2008

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

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

Mike wrote:
> 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
>
>
> On Apr 17, 5:45 pm, "Mike Glen" <glenATmvps.org> wrote:
>> 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=ArticleSe...
>> (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 wrote:
>>> 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- Hide quoted text -
>>
>> - Show quoted text -