How to Add Conditional Highlighting to Saved Search Columns in NetSuite

Saved searches in Oracle NetSuite natively support conditional highlighting of results, which can easily be configured on the Highlighting tab. This is a great option for simple highlighting requirements across full result rows, but how can you configure more complex needs such as changing the text size or adding a background color in a single column? In this video, I show how to use a bit of HTML code to create dynamic saved search highlighting logic that meets even the most complicated business requirements.
#NetSuite #OracleNetSuite #NetSuiteTutorial #ThatsSuite
ABOUT ME
My name is Sarah Emery and I am a "certi-fived" Oracle NetSuite ERP consultant and four-time SuiteWorld speaker with 13 years of experience. Prior to entering the world of implementing and consulting, I spent six years as a system administrator, where I developed my passion for NetSuite. Each week, I post quick videos to share some of the tips, tricks, and helpful hints that I've discovered over the years.
Visit my channel below:
/ @suitesarah
FOLLOW ME ON LINKEDIN
/ sarahameehan

[@Ashok_ON]

Hey Sarah, I've noticed something. It seems that when we use HTML formulas to highlight columns, the saved search doesn't appear to be available for dashboard view, even though the "available for dashboard" option is checked. Am I overlooking something here?

[@Mammon615]

Hi Sarah, I'm trying to use your tips and they work when I simply want the amount field changed. I'm having issues with a formula that uses WHEN (x field is true) THEN {amount} how do I put the color and the {amount} field past the THEN?