Help: Text Mode for Conditional Formatting on Current Task Details in a Project Report

[SarahSm]

I have a Project Report that pulls in the current task details (assignee name, task, and planned completion date) using the text mode below:

displayname=Current Task Details
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({canStart}=true && {status}!='CPL' && {numberOfChildren}=0,CONCAT("•",{assignedTo}.{name},": ",{name},"- ",{plannedCompletionDate}))
valueformat=HTML
width=270

I would like the cell to highlight red if the current task due date has passed. I can get the text mode to work if the planned completion date of the project has passed using the code below, but not sure how to write the code to work for the current task's planned completion date. Can anyone help? 

styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=plannedCompletionDate
styledef.case.0.comparison.lefttext=plannedCompletionDate
styledef.case.0.comparison.operator=lte
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.righttext=$$TODAY
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=

[BostonRae]

oopsie, nevermind. I just got it to work!

[BostonRae]

@lindselib i can't get it to work if it's "this or that". It works great if it's only one color. Can you shed some light on this for me?

[lindselib]

Are you talking about the background color of the cells? Actually I believe in the example I showed that conditional formatting was coming from another field on the report. My text mode in this specific column was only to throw certain emoji's (ie red dot or green dot) depending upon each task's due date (late or not). 

However, the users using this report have a field that is basically like "sub-status" of the project which they can use to flag projects in their list in certain states (ie "waiting on client," "needs attention," and so on). Depending on what they select, a different color is applied to the whole row (just using the built in conditional formatting). 

All that to say if you are wanting to apply a different background to the cell/row you may be able to add it in the code but if you want to save yourself some fiddling you may just be able to apply on a different column not using textmode!

Let me know if that doesn't make sense or if you have questions/need anything else.

-Lindsey

[BostonRae]

So insightful, thank you! We are using the reports broken out into groups (client review, planning, current, etc) but are finding during status check ins, it's not the easiest way to find things quickly. I think a single report with all in flight, color coded to match the project status is pretty smart. I'll build a few test reports with this idea. TYSM!