Colour changing Number field

[Chris Christou]

I am using FM Pro7 and have created a calculation field which dynamicaly changes colour depending on two other fields.

This works fine as long as the you set the Field to: Format > Number to Leave data formated as entered?

I would like the displayed Number to have 2 fixed decimal digits and a thousand separator ",".

Here is a copy of the Calculation field script called FieldC:

Case ( FieldA < FieldB ;

TextStyleAdd ( TextColor ( FieldB ; RGB ( 255 ; 153 ; 102 ) ) ; Bold );

TextStyleAdd ( TextColor ( FieldB ; RGB ( 51 ; 51 ; 51 ) ) ; Plain ))

Also attached is a test file.

Any ideas?

colour_test.fp7.zip