this.column1.DynamicBackColor='iif(yourfield1<0,RGB(255,64,64),RGB(255 ,255 ,255 ))'
this.column2.DynamicBackColor='iif(yourfield2<0,RGB(255,64,64),RGB(255 ,255 ,255 ))'
>>The Dynamic properties are avaluated on grid level so This in the expresion refers ro the grid not a column.
>
>
>hmmm, how can i then change the color of each individual cell depending on its value? is this possible with DynamicBackColor?
>
>
>>>
>>>3 years ago (or so) i had problems with that DynamicBackColor thing. doesn't seem i have learned anything in that time :-(
>>>
>>>the foloowing code causes the grid to error with "Expression is invalid. use a valid expr for Dyn..."
>>>
>>>the firld in the table is a numeric field and the columnCount=-1 in the grid to automaticly add the columns at run-time. the SetAll Command is issued after the grid receives ControlSource="MyTable"
>>>
>>>
>>>THIS._grid1.SETALL(;
>>> "DyNamicBackColor", ;
>>> "IIF(eval(This.ControlSource)<10,RGB(0,255,255),
>>IIF(BETWEEN(eval(This.ControlSource),10,20),RGB(0,255,0),RGB(255,0,0)))", ;
>>> "Column")
>>>