You can use nested IIF()s as Trey suggested or you can set the DynamicBackColor to a form-level functio/method. The method could have a CASE statement. When you have several options, some times this is a better way to go because of readability/maintainability.

HTH.

>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')