I have a nested table of refs (_ref_myMember_training_summary) within a detail view.
Each column will show "OVERDUE" or blank.
I want to add a Format Rule to highlight any columns which contain OVERDUE. See preview image.
I know I must define a "if this condition is true" logic and I can do this easily by specifying a unique column name - as in the preview below.
if this condition is true:
[_Providing Direction Overdue] = OVERDUE
How can I direct the Format Rule to look 'along' the row, highlighting any/all occurrences of "overdue"?
I want to avoid hardcoding the [column_name] into the if this condition statement to make it flexible in case the table columns change over time.
I've considered LIST and SELECT but don't see a way to work horizontally along a row, rather than vertically down a column. Thanks in advance for your generous time.
Solved! Go to Solution.
I'm afraid you need to do that column by column.
I'm afraid you need to do that column by column.
That's a terrific shame.
Thank you for reply so quickly.
You're welcome!
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |