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.