Question: How to Highlight a Custom review status field in Green Colour if the Review status is Approved and in red Colour if the Review status is Pending Approval.
Solution: Create a new Inline html transaction body field in SO and insert it after review status field and add the below below given formula as default value . By doing that we can give review status field in Green Colour if the Review status is Approved and in red Colour if the Review status is Pending Approval.
Default value :
CASE WHEN {custbody_kd_review_stat} = 'Approved' THEN '<div style="; background-color:lightgreen;display: inline-block;color:black;font-weight:bold">' || 'REVIEW STATUS IS APPROVED' || '</div>'ELSE'<div style="background-color:red;display: inline-block;color:black;font-weight:bold">' || 'REVIEW STATUS IS PENDING APPROVAL'||'</div>'END