Conditional Formatting in Project 2010

Resolved · Low Priority · Version 2010

Tue 3 Jul 2012, 15:51 Delegate Mark said...

Mark has attended:
Project Intro Intermediate course

Conditional Formatting in Project 2010

Is it possible to format conditionally from one column to another? This is as opposed to applying conditional formatting to bar graphics.

What I would like, for example, is to be able to have a have the % Complete column and if I type in 100 I'd like another 'Flag' type column to update to Yes. This in turn sets my bar graphic (which I can do through Bar Styles).

Thanks,

Mark

Thu 5 Jul 2012, 15:32 Trainer Rodney said...

RE: Conditional Formatting in Project 2010

Hello Mark,

Hope you enjoyed your Microsoft Project Intro Intermediate course with Best STL.

Thank you for your question regarding conditional formatting in Project 2010.

First of all right-click any column heading in the table area and select Custom fields. Choose a Flag option from the top right drop-down. Click the Formula... button and type the following into the formula area.

IIf([% Complete]=100,"Yes","No")

Then insert the column to observe what it does when a task is marked as complete. A 'Yes' will appear. Then edit the Bar Styles by adding another row called Task Complete and in the Show For... column select the Flag field you have added the formula to. Modify the appearance as required.

Give this a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Thu 12 Jul 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Giving Someone a Gantt Chart Snapshot

To pass on a picture of a Gantt chart segment, choose the appropriate view, select the rows to be included, then click on the camera icon and select For Screen. The graphics image can be pasted into another document. (See Paste icon forn Project 2010)

View all MS Project hints and tips