Skip to main content
Topics#Data ManagementBrendon Montgomery's Question
Brendon Montgomery asked in #Data Management
Apr 27, 2012, 3:59 PM

How do I Color Code Formula Fields??

I set up a formula field to divide two other fields and give me a value. Now I want it to look like this:

 

If the value <55, the cell will be Green

 

If the value between 55-60, the cell will be Yellow

 

If the value is >60, the cell will be Red

 

How can I set up the color coding part?

 

Thanks in advance.
2 answers
  1. Shivakumar K.M (TCS)
    Jun 15, 2022, 12:45 PM

    Use CASE() function to achieve above requirement:

    Note: The CASE() function is a powerful Salesforce tool that allows users to simplify formula writing, stay within compile limits, and create cleaner, easier to read functions versus using long and clunky nested IF() statements.

     

    CASE(fieldname, 

    "Green(field value)",IMAGE("/img/samples/color_green.gif", "Green", 30, 30),

    "Amber(field value)",IMAGE("/img/samples/color_yellow.gif", "Amber", 30, 30),

    "Red(field value)",IMAGE("/img/samples/color_red.gif", "red", 30, 30),

    "") 

Write an answer...
0/9000