Loading...
Quick Links

MPUG Tip – Apply Conditional Cell Background Formatting for New Tasks Added through Change Control

“People ask if there’s any kind of conditional formatting in Microsoft Project the way there is in Excel and the reason that folks ask this question is because Microsoft Project behaves in many ways like Excel and it looks like Excel, there’s gotta be conditional formatting.” Watch this video to find out what kind of conditional formatting you can do with Project!

Take a look at our other quick and easy MPUG tips from Dale. Have a suggestion for a tip or a how to? Let us know.

Share This Post
9 Comments
  1. Great presentation, used it right away to mark calculated Critical path tasks to a given task.

    Reply
  2. Thanks Dale, I’ve found this very useful.

    Is there any way of adding multiple “marked” columns so more than two task types can be formatted?

    For example, I’d like to use light green to mark a “client contractor task”, light blue for a “sub contractor task” and no color for a “company task”. What I’ve found is inserting multiple “marked” columns auto populates the new column with the yes/no of the existing column and any changes are duplicated in both columns. The result is I’m unable to use different cell backgrounds for “client contractors” and “sub contractors”.

    Any thoughts or insight would be much appreciated.

    James

    Reply
  3. James — Good question. No, there is no way to use multiple Marked fields as you describe. The software only offers a single Marked field which you can use to format tasks. Sorry. Hope this helps.

    Reply
  4. Questions for Conditional formatting. I’d like to have different background colors automatically populated for: Completed Tasks (GREEN); Late Tasks (RED); In Progress Tasks (YELLOW). How do I do these automatically?

    Reply
  5. Brian —

    Short of writing a macro in VBA to do this for you, there is no built in method to force Microsoft Project to automatically display background colors for the situations you describe. As far as workarounds, you might try inserting the Status and Status Indicator columns in a task view, or try applying grouping using the Status column in a task view. Hope this helps.

    eDale

    Reply
  6. Dale,
    In the % Complete column, once a task is changed to 100%, is there a way for a cell background color to be added automatically? Like changing that cell background to green at 100%?

    Reply
  7. Mike —

    Sorry, but no, this is not possible using the options available in the Text Styles dialog. Hope this helps.

    Reply
  8. Is there a way to change the formatting of only the % complete bar within the gantt bar. I am trying to make it more visible…black

    Reply
  9. Dan —

    If you want to change the % Complete bar for EVERY Gantt bar, double-click anywhere in the white part of the Gantt Chart pane. In the Bar Styles dialog, scroll down to the bottom of the dialog and select the Progress item. Change the Color of the Middle item to Black and then click OK. Hope this helps.

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

Thanks for submitting your comment!
You must be logged in to comment.