March 11, 200916 yr 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
Create an account or sign in to comment