I have a datagridview.

I want to format the rows back color along the lines of the following

If row.cell(0).value = "Yes" then
row.backcolor = red
else
row.backcolor = green

How do I do it, I have trapped the datagridview.cellformatting event - is that correct? Unfortunately thats as far as i've got.

Many thanks