Task Views and Reports - Show where Commit Date is greater than Planned Completion Date

[MeghanKa]

I'm looking for a way to format the Commit Date column in reports and task views that will show the date in red if it's greater than the Planned Completion Date. If anyone has text mode for this that would be really helpful!

[Kelly_Wehrmann]

Try this in a report....add a new column, convert to text mode, and paste this code in... displayname= linkedname=direct namekey=commitDate querysort=commitDate styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=commitDate styledef.case.0.comparison.lefttext=commitDate styledef.case.0.comparison.operator=gt styledef.case.0.comparison.operatortype=date styledef.case.0.comparison.rightmethod=plannedCompletionDate styledef.case.0.comparison.righttext=plannedCompletionDate styledef.case.0.comparison.trueproperty.0.name=fontstyle styledef.case.0.comparison.trueproperty.0.value=bold styledef.case.0.comparison.trueproperty.1.name=textcolor styledef.case.0.comparison.trueproperty.1.value=d30519 styledef.case.0.comparison.truetext= textmode=true valuefield=commitDate valueformat=atDate

[MeghanKa]

That worked! Thanks a bunch!