Give all the fields in the row of your table view the same conditional format formula.
I must be missing somethng. The remaining fields will not have the same data so they will not respond to the condition I have set. I can't seem to reference the one field that contains the condition with any of the remaining fields.
If you use the "formula is" instead of the "value is" option in the conditional format, you can set up an expression that checks the value of a different field other than the field being formatted in order to determine whether or not to apply the conditional format.
You can use an expression like this:
Table::field = "Complete"
But use your table name, field name and value to be checked to determine whether or not to apply the format. You can actually select all the fields on your layout and apply this same expression to all of them.