Project 2000 - Change colour of cell text based on formula

[Maver1ck666]

Hi everyone,

Im fairly new to Project so am still exploring so apologies if this is a
simple question.

Is it possible to change the colour of the text in a cell based on the value
of another cell?

For example, I have a number of columns (some will be hidden) that tells me
when a review is due. Part of my project gantt chart looks like this:

Overdue Review Date
True 30/09/2009
False 01/10/2009
False 12/10/2009

In the overdue column, I currently have the formula:

IIf([UserReview]<Date(),"True","False")

What I would like is for the colour of the text in the review date to change
to red when the flag in overdue is currently True. Is that possible please?

Kind rebards,
Mav

 

[Rob Schneider]

Probably *could* do it with VBA code ... but that's too hard. I
recommend you use Project's built-in capabilities to note status of
tasks with the field "Status Indicator". You can read in Help how this
field is computed by Project for you.

If you want more colours, you could display a custom number field with
graphical images based on the the value of the status indicator field
(or any other field). Lots of colours, symbols, etc. are available.
See this in the cutom field dialog bux, button "graphical indicators".
Also a Help button there which explains it all.

--rms

www.rmschneider.com

 

[JulieS]

Hello Mav,

Welcome to the Project newsgroup. As Rob noted, there is not
automatic method of accomplishing what you are looking for --
changing the text color based upon a value of another piece of
information.

However, you can add your formula into a custom Flag field (Flag1,
Flag2) and then create a highlight filter based upon the Flag field
criteria. To go even further, you could create a custom view with
the Highlight filter automatically applied.

Fellow MVP Mike Glen has an excellent series of free tutorials you
can work through, several of which address both custom graphic
indicators such as Rob mentioned as well as creating custom views.
You can find Mike's tutorials through the MVP web site:

http://project.mvps.org/mike's_tutorials.htm

I hope this helps. Let us know how you get along. Feel free to
post back with additional questions as you need.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Maver1ck666]

Thanks for both of the replies. I had managed to find something Mike Glen had
done which seemed to have worked better (graphical identifiers).

I have however, got a new issue but will raise that in a seperate question.

Thanks again!

Mav