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