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

Highlighting column value when evaluating 2 conditions

  • February 12, 2026
  • 2 replies
  • 42 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

Best answer by Richard_Le_

Hi ​@NickVa7 ,

To my knowledge you can only apply one formatting rule per condition. i.e. Make the column Red if {plannedCompletionDate} < $$NOW OR make the column Red if {status} != CPL

Two conditions for the same formatting rule is not possible (AND).

Furthermore, you cannot use a value expression to apply the formatting rule. The textmode will only accept a qualifier such as greater than (gt), less than (lt) etc.

You can only apply formatting by comparing one value against another.

You can read more on the text mode syntax for conditional formatting here

 

I would recommend considering a formatting rule for if the actualCompletionDate is greater than the plannedCompletionDate. Although this isn’t quite the same as your requirement, it would allow you to highlight values where the task is Complete and where the completion date is after what was originally planned.

Best Regards,

Rich.

2 replies

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
February 17, 2026

​@Doug_Den_Hoed_AtAppStore ​@Richard_Le_ ​@KIMBERLYREA ​@Sven-iX ​

Pulling you into this discussion to get your take, especially if there are best practices we should be thinking about. Thanks in advance for any input you can share.

Kautuk Sahni
R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
February 17, 2026

Hi ​@NickVa7 ,

To my knowledge you can only apply one formatting rule per condition. i.e. Make the column Red if {plannedCompletionDate} < $$NOW OR make the column Red if {status} != CPL

Two conditions for the same formatting rule is not possible (AND).

Furthermore, you cannot use a value expression to apply the formatting rule. The textmode will only accept a qualifier such as greater than (gt), less than (lt) etc.

You can only apply formatting by comparing one value against another.

You can read more on the text mode syntax for conditional formatting here

 

I would recommend considering a formatting rule for if the actualCompletionDate is greater than the plannedCompletionDate. Although this isn’t quite the same as your requirement, it would allow you to highlight values where the task is Complete and where the completion date is after what was originally planned.

Best Regards,

Rich.

    N
    NickVa7Author
    Level 9
    February 17, 2026

    Thanks, ​@Richard_Le_ and ​@kautuk_sahni .  Good to know.

    Terms & ConditionsAccessibility statement

    Loading footer...