I would like to highlight rows in a grid based on a status field in the view. Right now i can set the background color for just one 'situation' but not multiple. For example, i would like to show PaidInFull rows in green, payment greater than zero (but not in full) in yellow, and where not paid at all in pink. I can do this for just one situation but not for all three.

Can anyone suggest a technique?

------------------------------------------
i use the following to set the background:
------------------------------------------

thisform.pgfpagerefresh1.page1.grdnav.setall('DynamicBackColor', ;
'IIF(v_view.totpaid = 0, ;
rgb(255,128,128),rgb(255,255,255))', ;
'COLUMN')

thisform.pgfpagerefresh1.page1.grdnav.setall('DynamicForeColor', ;
'IIF(DATE()=DATE(), ;
rgb(0,0,0),rgb(0,0,0))', ;
'COLUMN')