Conditional formatting based on Condition and Percent Complete

[tlangford]

Hi Community

I've created a project report that highlights projects where the condition is 'At Risk' in orange or any that are 'In Trouble' in red. However, this should only be applied to incomplete projects (where Percent Complete < 100).

So, the one At Risk should be highlighted orange but the one In Trouble should not be highlighted red, as Percent Complete = 100.

None of the other rows should be highlighted, as they're On Target.

I've tried various combinations of cases in the text editor, without success. Any help would be appreciated..

thanks

Tony

[KellieGardner · Accepted solution]

So you can trick the system with conditional formatting by setting up 2 conditional statements. Workfront will go down the list and apply the first format and then the second format.

Set your first condition to color the completed projects white, then set your second condition to color the at risk or in trouble projects.

[tlangford]

It's easy when you know how

Thanks!

[KellieGardner]

Took some trial and error over the years. Even if you are new, you'll get there. It calls out the order on the documentation page but doesn't explain how you can use it for something like this very well. It's kind of similar to Excel conditional formatting.

Rules are applied in the order that they were created. They are combined but they do not overwrite each other..

[MichD2]

Hi Kellie

I want the due date to show in red, if it's late, but not if it's 100% complete.

Any Ideas?

Thank you!

[tlangford]

Hi MichD2

As Kellie wrote, each rule is applied based on when it was created, so if you make sure the last rule (the top one) is the same as the one I have in the screenshot, this will supersede any other rules that apply formatting.

Hopefully that should do what you need it to do...

thanks

Tony

[MichD2]

Thank you, unfortunately not. I actually want this to show in the project tasks, not a report and that doesn't seem to work.

Thanks though!