i have the following formula on a saved search which is displaying customer amount balance on the results max({total}) - sum({applyingtransaction.amount}). my team would like me to highlight all orders with less then $5 balance. i did the following but got no results max({total}) - sum({applyingtransaction.amount}) < $5

Is this a summary search? Try using the summary tab under the highlighting subtab