In a Task Report how can I display a red background row IF the Task Due Date ends before the Project Due Date?

[joes68374352]

Hello Workfront Community!

I have made many attempts in Columns (View) | Text Mode | to create a report but had no success.

The Task Report criteria is:

IF the Task Due Date ends before the Project Due Date, turn the background red.

Thank you for reading!

Kind regards,

- Joe

[Doug_Den_Hoed__AtAppStore]

Hi Joe,

One way to compare fields in conditional formatting is shown here, which you could use show plannedCompletionDate less than project.plannedCompletionDate in red.

Regards,

Doug