Hi Albert,
try it like this:
Thisform.Grid1.Column3.DynamicBackColor = [ThisForm.SetBackColor(amount)]
Within Thisform.SetBackColor you can define the Backcolor with regular Code, which can be handled much better than IIF or ICASE within the property itself.
LOCAL liReturn
DO CASE
CASE amount < 100
liReturn = RGB(255,0,0)
CASE BETWEEN(amount,100,1000)
liReturn = RGB(255,255,255)
CASE amount > 1000
liReturn = RGB(0,255,0))
ENDCASE
RETURN liReturn
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
