+ Start a Discussion
Hitesh KhannaHitesh Khanna 

how do i change color of my text in formula field to Red ?

this is the formula and i want to display text in red colour.

IF( Contract_End_Date__c <  TODAY() , "Please do not utilize the playbook. The contract is no longer active" , " ")
Best Answer chosen by Hitesh Khanna
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Hitesh,

You cannot achieve it through formula field. But You can create a field of Rich text type and update the field using the workflow rule update by using the below formula.
 
IF( Contract_End_Date__c <  TODAY() , '<html><body><div style="color: red;"><b>' & "Please do not utilize the playbook. The contract is no longer active" & '</b></div></body></html>'  , " ")

Please find the similar question answered in Stack Exchange.

https://salesforce.stackexchange.com/questions/276487/make-text-highlighted-red-bold-if-criteria-is-met

If this solution helps, Please mark it as best answer.

Thanks,
 

All Answers

Sai PraveenSai Praveen (Salesforce Developers) 
Hi Hitesh,

You cannot achieve it through formula field. But You can create a field of Rich text type and update the field using the workflow rule update by using the below formula.
 
IF( Contract_End_Date__c <  TODAY() , '<html><body><div style="color: red;"><b>' & "Please do not utilize the playbook. The contract is no longer active" & '</b></div></body></html>'  , " ")

Please find the similar question answered in Stack Exchange.

https://salesforce.stackexchange.com/questions/276487/make-text-highlighted-red-bold-if-criteria-is-met

If this solution helps, Please mark it as best answer.

Thanks,
 
This was selected as the best answer
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Hitesh,

Were you able to follow the steps?

Thanks,