3 Replies Latest reply on Apr 29, 2012 12:38 AM by Sorbsbuster

    Conditional Formatting for all records

    VanessaAnne

      Title

      Conditional Formatting for all records

      Post

      Hello, 

      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.  

      Thank you!