How to apply Format Rules to any column in a row without having to specify every column?

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.

gcor71_1-1696848986482.png

gcor71_0-1696848904659.png

 

Solved Solved
0 3 199
1 ACCEPTED SOLUTION

I'm afraid you need to do that column by column.

View solution in original post

3 REPLIES 3

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!

Top Labels in this Space