Hi!

You're on the right way <s>!

You have to use the DynamicForeColor/DynamicBackcolor properties.
This props contains strings, which will be evaluated for every row!

You can deal with IIF:

...DynamicBackColor = "IIF( MyField = 'M', RGB(255,0,0), RGB(0,0,255) )"

You're also free to call self defined function to calculate the colors:

...DynamicBackColor = "ThisForm.CalculateColor( "MyField", MyField )"

------------------

* ThisForm.CalculateColor
LPARAMETER tcFieldName, tuFieldValue
* do something depending on tcFieldName, tuFieldValue
* to fill the return value
...
RETURN lnColor

BTW: Be aware of having a lot of code called by DynamicColor makes the grid slow!