98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Project Training and help » Conditional Formatting in Project 2010
Conditional Formatting in Project 2010
Resolved · Low Priority · Version 2010
Tue 3 Jul 2012, 15:51Delegate 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:32Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Giving Someone a Gantt Chart SnapshotTo 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) |
