I think you need to go with Srini's suggestion

Have you tried putting conditional formatting on your row in your template? ​ would probably be the better place to post question. Janel

That sounds great but is completely beyond my control. AFAIK there is nothing publicly facing and isn't in the works...everything is kept inhouse. Also I think our users want this information for themselves as well so they can monitor the supplier performance.