Formula Field to show color when a value of Custom Field lies in a certain Range

Recently, I go through a scenario where I need to showcase different colors when a value of a custom field lies in a particular range for example.
We have a Rating Field over Account with API name as Rating__c

If Rating belongs to 0 – 3 show Red
If Rating belongs to 4 – 6 show Yellow
If Rating belongs to 7 – 9 show Green

Learn more about Salesforce Flow Bootcamp

Solution:- Create a Formula Field with Return Type as Text

Paste the Below Formula into the Formula Builder

IMAGE
(
IF(AND(Rating__c <=3, Rating__c >=0),"/img/samples/flag_red.gif", IF(AND(Rating__c >=4, Rating__c <=6),"/img/samples/flag_yellow.gif", IF(AND(Rating__c >=7, Rating__c <=9),"/img/samples/flag_green.gif","") )

),
"",15, 15
)

Register for Salesforce Flow Bootcamp

that’s how you can achieve the above scenario.

Get complete Roadmap To Learn Salesforce Admin And Development 👇

Name *

First

Last

Email *

Comment or Message

Submit