Thank you this is helpful. We're working with a consultant on getting workfront up and running in our company and I also raised the issue with him but have not heard back yet.

Thanks!

Nicole, Actually, I want to apply this rule to my project, not a report. So when the task is completed at 100% (marked as done) the "red" text will revert back to black showing it isn't past due. Is there a way to do this?

Thanks so much, it was very helpful!

Thank you!