asked on

MS Project Conditional Formatting

Greetings,

I just converted my task tracking from Excel to Project and found that CF is only available via VBS. I want to have a condition where 100% in the % Complete column would fill the cell with bright green. Would you help me explore making that happen. I so appreciate your help, in advance!

Thank you,
johnD

Professor J

do you want the CF in Excel or in MS project? i did not understand

John Darby

ASKER

MS Project, please

Professor J

which version you have?

John Darby

ASKER

MS Project 2010 Standard

Ivan Rivera, MTI, SCPM, ITIL, Cobit, PMP

Hello John.

Take a look at this article:

http://markgrohman.com/vba-macros-for-microsoft-project-2013/

Hope I can comeback with few samples.

Professor J

there is a microsoft project add-in commerial version 15days trial period as well.

http://www.chroniclegraphics.com/howto/conditional_formatting_in_project.html

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Darby

ASKER

Thank you, ProfessorJJ,

it makes lines of text green irrespective to whether % Completion is 100% or not. I am looking to see if I can alter what you've given me, though

Thank you,
JohnD

John Darby

ASKER

I am working with Cell.CellColor, now

Martin Liss

I've requested that this question be closed as follows:

Accepted answer: 500 points for ProfessorJimJam's comment #a40860301

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

John Darby

ASKER

Thank you!