Jump to content

Colour changing Number field


This topic is 7238 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 7238 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.