Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.

Multiple Text Mode Statements for Report Field Conditional Formatting


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


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


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