function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nish321Nish321 

Field value in color - Standard page layout

I would have to autopopulate a field in Case object from Account object.    The field value should be colored (Eg: Green) or highlighted.  How can I accomplish this using a formula ?
Carlos Campillo GallegoCarlos Campillo Gallego
Hi Ramshah,

I'm not sure of having understood what you want but I guess that you want to create a formula field that shows an image (a color) depending on an Account field value.
If that's what you want, you can use something like this:  
IMAGE( 
CASE(  Account.Account_Field, 
"Green", "/img/samples/light_green.gif",
"Yellow", "/img/samples/light_yellow.gif",
"Red", "/img/samples/light_red.gif", 
"/s.gif"), 
"Traffic Light")

Account_Field is a picklist with three picklist values (as you have already guessed they are green, yellow and red) and this formula field shows a traffic light depending on this field value.

There [1] [2] links may be helpful for you.

Regards

[1]
https://help.salesforce.com/HTViewSolution?id=000007604
[2]
https://help.salesforce.com/apex/HTViewHelpDoc?id=useful_advanced_formulas_image_links.htm&language=en_US
Nish321Nish321
Hi Carlos,

Thanks for your reply. My requirement is not to display the image but to display a text value in color.