Changing colors based on field calculations

[manatee]

Can anyone advise on the best method for changing colors of a field based on a calculation? Essentially we have amount1 divided by amount2 and if the amount is over 70% we want the field text to be red. If it is under then it stays black.

Thank you a ton!

[Ocean West]

Let ([

_value = Amount1 / Amount2

] ;

Case (

_value > .70 ;

TextColor ( _value ; RGB ( 190 ; 0 ; 0 ) ) ;

TextColor ( _value ; RGB ( 0 ; 0 ; 0 ) ) )

)

[manatee]

Thank you very much. I need to look at this "let" function more closely. I do not recall this in FMP7.