I have a datagridview in my project which is bound to a dataset.

The grid populates fine, but I'm looking to do something a bit more.

One of the columns is called "Status" and right now it returns the ID from the database in this column (e.g. "13", "14" etc). I'd like to substitute this value with it's associated color so if it's "13" set the cell background to green, if it's 14 set it to yellow and so on.

Just not sure a) where to put this code and b) how to do it.

Thanks