8 Replies Latest reply on Nov 16, 2009 7:50 AM by raybaudi

    Calculation for Conditional Formating

    AAgraphics

      Title

      Calculation for Conditional Formating

      Post

      Using FMP10

       

      I need help creating a formula comparing values in 20 different fields.  I want the lowest value out of all 20 fields to be in a green box.  Here is difficulty I am having, if any of the fields are empty, I do want the formula to include them.

       

      So the formula has to evaluate the values in all 20 different fields, provided that there is data in the field, if and fields are empty or equal to zero, the values in those fields should not count.

       

      If you have any questions, please let me know. 

       

      Any thoughts?