Highlight a specific cell in the Saved Search result for values that reached certain criteria.
For example, add a column in Saved Search Results that will show ‘Pending’ in red bold text with the yellow background if the Memo field in the Sales Order is null. Otherwise, the word ‘Done’ should be displayed in black italic text with green background.
On the Results subtab of the search Select Formula (Text)
Enter: Case WHEN ({memo}) != ‘null’ THEN ‘<div style=”color:#ff0000;font-weight:bold;background-color:#FFFF00″>’||’Pending’ ||'</div>’ ELSE ‘<div style=”color:#000000;font-style:italic;background-color:#008000″>’||’Done’ ||'</div>’ END
Another Example: To hight a cell in the saved search that will show Due Date in black bold text with green background if the Due date field has value, otherwise, the cell will be blank.
Case WHEN {duedate} != ‘null’ THEN ‘<div style=”color:black; font-weight:bold;background-color:#cce57f”>’||{duedate} END