How can I use conditional formatting to make the completion date (due date) turn red when the task is past due? Thanks!

If you add multiple display rules to an object, the rules are applied from bottom to top. Use that to your advantage.

Even though you cannot use an AND statement in formatting rules, this hierarchy allows you to simulate (hack) OR statements and boolean statements as each rule is superceded by the one above it.

Simple example:

I want to highlight all tasks without a predecessor in red, but not parent tasks as they should not have a predecessor anyway.

I create a rule that says "If number of children greater than 0 then background is white"

Below that is a rule that says "If entered by ID is blank then color background red"

The result is:

Rule 1 (bottom rule): if there is no predecessor, the background turns red

Rule 2 (top rule): If it's a parent task turn background to white again

In your case, maybe you could say

Bottom rule: if task past due turn red

Top rule: If task complete turn black

@Linda Gonnella‚ If you open your report and select on the Due Date column, select Advanced Options in the top right. Scroll down to the Column Rules section and click on +Add Column Rule. Set your statement to read

When the: Task > Planned Completion Date > Less Than > $$TODAY

Then, choose red in the background drop down menu. Click Add Rule and then Save and Close your report. Keep in mind that your report should be filtering for incomplete tasks (Task Status > Not Equal > Complete) so only those that are incomplete and past due will show with a red background.

If you have any questions, let me know!