Highlighting column value when evaluating 2 conditions | Community
Skip to main content
Level 9
February 12, 2026
Question

Highlighting column value when evaluating 2 conditions

  • February 12, 2026
  • 0 replies
  • 0 views

Hi WF Community!

I’m looking to add red highlighting to values in a project’s task list, under the Planned Completion Date column, when the date is less than $$NOW and the task’s Status is not equal to “Complete”.

 

I was working with leftmethod in text mode on the Planned Completion Date column, but still not getting the result I need.  Here’s my text mode:

 

displayname=Planned Completion Date
linkedname=direct
namekey=plannedCompletionDate
querysort=plannedCompletionDate
textmode=true
valuefield=plannedCompletionDate
valueformat=atDate
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=AND(({plannedCompletionDate}<$$NOW),({status}!=”CPL”))
styledef.case.0.comparison.lefttext=true
styledef.case.0.comparison.operator=equal
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=

 

Anyone know where I might be going astray?  

Thanks!

Nick