I have two number fields on opportunity layout. A and B. I want to create a formula field and when A>B the formula field will be red or just an indication that people will notice it right away when they are creating an opportunity that A should not be greater than B. When A<B it will be just regular without any indication. How could I do this?

IF ( A > B, "BAD", "GOOD") This is what I did to display text, but some colors or other indications will be better for someone to not miss and notice it easier compare to a displayed text.

1 Answer 1


You can use the IMAGE formula field to accomplish this.

Your formula will be as below

IF (A > B, 
      IMAGE("/img/samples/color_red.gif", "red", 40,40),
     IMAGE("/img/samples/color_green.gif", "green", 40, 40)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.