>>>My grid is driven by a table called collections
>>>
>>>If the service column of any record contains any one of the following I want that row to be black, otherwise red
>>>
>>>STANDARD
>>>ECONOMY SERVICE
>>>STANDARD (EXPRESS)
>>>ECONOMY
>>>
>>>and where do I put the relevant code?
>>
>>Sorry I want the forecolor only to change
>
>You can put condition for DynamicForeColor in grid's Init, e.g.
>

>thisform.myGrid.SetAll('DynamicForeColor', 'iif(inlist(Service,"STANDARD","..etc."), rgb(...), rgb(...))','Column')

>
>You can also create condition separately using TEXT ENDTEXT, e.g.
>

>text to lcCondition noshow
>   IIF(INLIST(Service, 'STANDARD', ..),rbg(..), rgb(..))
>ENDTEXT

>
>and use lcCondition inside the SetAll method.

Naomi

I think I see what you mean but I'm not sure

Any chance you could give me the complete code

Thanks

Colin