how do I dsplay a negative number in red

I have this formula in a field.

Cloud_usage_hours_purchased__c - Cloud_usage_hours_used__c

If the result is a negative number, how to I display that number in red in the field?

4 answers

Sathishkumar Periyasamy (Eastman Kodak Company)
Feb 3, 2017, 7:46 PM
You can't display the negative number in RED instead of the you can display

IF((Cloud_usage_hours_purchased__c - Cloud_usage_hours_used__c) > 0, IMAGE("/servlet/servlet.FileDownload?file=01570000000Q6El", "Green"), IMAGE("/servlet/servlet.FileDownload?file=01570000000Q6Ep", "Red"))

Add a comment

0/9000

Data Management