You have to do it in a big long, (ugly) iif() statement in the init of the grid. I only have two colors besides the normal and it looks like this:
THIS.SETALL("DynamicBackColor", ;
"IIF(alltrim(nxtact_st) == '0', IIF(dte_nxtact - loData.dredactdate > 0, ;
IIF(dte_nxtact - loData.dyellowactdate > 0, RGB(255,255,255), RGB(255,255,128)), ;
RGB(255,0,128)), RGB(255, 255, 255))", "Column")
>I have tried multiple colors in a grid before but so far have not cracked it even with help from the experts
>
>Let me try again
>
>I have a table called manifest which has a field called status
>
>If status is A I want to color the row blue
>If B the row will be red
>If C the row will be green
>
>How do I do it?
>
>A real layman's explanation would be greatly appreciated
>
>Thanks
>
>Colin Northway