Conditional Formatting for all records
I am able to conditionally format a field to a "gray" color by assigning it's value to be dependent on "yes." When this field's value is yes, I would like that color to be applied to all fields in the same record.
I am aware of coyping the formatting to all fields, but since the values are different - varying from dates, numbers, texts - the conditional formatting does not work since it can't be dependent on value.
I'm assuming I need to create a formula, but am not sure what it should be.
I am on FMP11.