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

Register for Salesforce Flow Bootcamp

that’s how you can achieve the above scenario.

Get complete Roadmap To Learn Salesforce Admin And Development πŸ‘‡

Share Now

Shubham is the Founder of Salesforce Geek. He is also a Salesforce Certified Consultant.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *