>Hi Rick,
>
>To elaborate a bit on Ed's response,<s> I am sure you would like to see an example of how DynamicBackColor and DynamicForeColor Properties work.
>
>This example toggles the backcolor of a column based on whether the value of recno() is even or odd: Iif(mod(recno(),2)=0,rgb(255,0,0),rgb(255,255,255)). In code, you would do something like:
>
>frmFoo.Grid1.Column1.DynamicBackColor = ;
> "Iif(mod(recno(),2)=0,rgb(255,0,0),rgb(255,255,255))"
>
>Or... you can issue this code:
>
>frmFoo.Grid1.Setall("dynamicbackcolor", "Iif(mod(recno(),2)=0,rgb(255,0,0),rgb(255,255,255))","column")
>
>Just replace the Iif expression with the logical value stored in the table.


OK,

BUT , how about multiple row color ??

eg. when xx=1 then color=red
when xx=2 color=bleu
xx=3 color=green
...

Greetings,

Marc