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
SargeSarge 

Colouring the text in Formula field

Hi , I have a requirement to show the text appearing in formula field in red color . Is it achievable? The exact requirement is to show a auto Number type field in red if the Target Date field value is behind today's date. And the color should be seen not only in detail page but also in search results. I am wondering if this could be achieved using formula field.
Ritesh AswaneyRitesh Aswaney

I doubt if this is possible to format text, coz I don't think formula fields deal well with HTMl content. It is however possible to display a a an image such as a colour, or if you have limited values, then you could create images of the text in various colours, and then display them using image formula fields.

 

For image formula fields, this discussion thread has what you'd need :

http://boards.developerforce.com/t5/Formulas-Validation-Rules/Image-formula-based-on-Lead-Score/m-p/110959/highlight/true