I have a grid I need to have many different row colors based on the value of a field. Easy enough using an IIF in the DynamicBackColor property. However, I need to check for about 15 different values. Obviously, I can't nest IIF's this deep. My next idea was to created a method in the grid class which returns the proper color, but this doesn't seem to work either.

Any suggestions?