Expand my Community achievements bar.

Multiple Text Mode Statements for Report Field Conditional Formatting

Avatar

Level 10
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
2 Replies

Avatar

Level 10
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

Avatar

Level 10
Thanks for the suggestion, David! I might give this is try, if the team wants to add a new field. Nick Valeriote