I have a grid with several columns of data in. I have set the property "Allow Cell Selection" to false so that the user can not change any values in the grid. I want to change the font color of the text in the text box under two conditions.

Condition 1
- If the value in a text exceeds a certain value then the font must be read of for that text box

Condition 2
- The text box in certain colums must be bold and in another color when the current row is highlighted.


So if you look at the screen capture of my grid. I want the following:
- values in the 3rd column to be red if the value is above 50
- i want the value in the 3rd, 4th and 5th column where the row is highlighted to be bold and in another color.

Is this possible and how do I go about doing this.

Thanks in advance.

Stuart