Help....

I have been tring to create a grid that will change foreground and backcolors of the fields based on the data in thw database. I have tried using IIf statements and they work if I want only 2 color options, I am tring to get a total of 4 color options for each the foreground and the background.

I have tried using case statements but then the grid does nothing.

Any ideas??????

Rich