The secret is to keep the whole expression inside parentheses.
yourgrid.column3.DynamicForecolor = 'iif(mytable.myvalue>5, rgb(255,0,0), rgb(0,0,0))'
yourgrid.setall('DynamicFontBold','iif(mytable.mavalue=0,.F.,.T.)','column')
You may also need to change the column's sparse property.
>Hi Marc,
>
>Thanks for the input. I have managed to change the columns to bold that I needed with:
>
>this.column3.DynamicFontBold = '.T.'
>
>My problem now, is how do I change the font color for a particual record on the grid for that column. For example if I want all values in a column to be red if they are above a certain value.
>
>I also want to be able to change the color of all the text in the hightlighted row or make them bold. All the other rows must stay the same.
>
>An Idea. I have been trying various things but no joy