If the price field is less than 100 (for that row), I would like to display just the price field in red otherwise in black. Also, if the user modifies the price the foreground colour should change as necessary.
>In other words, some prices may have a foreground colour of black and others - red.

Use this for the column's DynamicForeColor and refresh the grid when the user changes the price.

IIF( MyTable.PriceField < 100, RGB( 255, 0, 0 ), RBG( 0, 0, 0 ) )