[RESOLVED] DataGridView - setting the colour of a row?

[tgf-47]

I have a dgv where every alternating row is a different colour to make it more readable, as you can see in my attachment.

I now want to recolour certain rows to another colour. Lets for example say all rows where column(7).value < 5 should be red or whatever.

I coloured 2 rows in the example to show you what i want.

Is this possible?
if yes, how?