AnsweredAssumed Answered

Calculation for Conditional Formating

Question asked by AAgraphics on Nov 11, 2009
Latest reply on Nov 16, 2009 by raybaudi

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? 

Outcomes