Color field by weight left!

[tmas73]

I have a field in the same layout that displays a total weight of a product in stock. By the use of the product the weights gets lower, I have a conditional calculation that makes the text red when it reaches minus (-). Is there a way to calculate the color green when the weight hits close to zero (0) amount like as a warning that the product is low in stock.

so for example

1000 g - regular color

50g - green color

-1 - red color.

How can that be done?

Thanks

[aldipalo]

Does this help?

Materials.zip