Multiple Text Mode Statements for Report Field Conditional Formatting | Community
Skip to main content
N
NickVa7
Level 9
December 10, 2019
Question

Multiple Text Mode Statements for Report Field Conditional Formatting

  • December 10, 2019
  • 2 replies
  • 707 views
Hi WF Community, Goal: Apply conditional highlighting to column values in a report based on multiple criteria. For example, I want to highlight in red, the cells the Duration column of a task report, where the Duration field value = 0, AND the task Status is not equal to New. Do I need text mode for this, and if so, any idea what that might look like? Thanks! Nick Nick Valeriote
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

D
DavidCo3
Level 10
December 13, 2019
Hi @Nick Valeriote - I haven't tested this but I'm pretty sure the only way you could do this is to use a calculated field with nested IF statements which does the evaluation of the two conditions and then would store a certain result value if both are true. Then you can use the regular conditional formatting user interface to apply the formatting if the value of the calculated field matches. David Cornwell
N
NickVa7Author
Level 9
December 16, 2019
Thanks for the suggestion, David! I might give this is try, if the team wants to add a new field. Nick Valeriote
Terms & ConditionsAccessibility statement

Loading footer...