Hi All

I have a grid which I want to set the forecolor based on a value, the code is like this:

oGrd.SetAll("dynamicbackcolor", "", "Column")
oGrd.SetAll("dynamicforecolor", "", "Column")

oGrd.SetAll("dynamicforecolor", ;
"IIF(Credit > 0,RGB(0,121,0), RGB(198,0,0))", "Column")

The above works fine, but I want to change the color of column 6 according to the balance value, so i tried:

oGrd.Columns[6].SetAll("dynamicforecolor", ;
"IIF(balance > 0,RGB(0,0,255), RGB(0,0,0))", "Column")

also tried
oGrd.Column6.DynamicforeColor = IIF(balance > 0,"RGB(0,0,255)", "RGB(0,0,0)")
and again no luck.

Any help is much appreciated.

Thanks