>It used a method in the grid that had a case statement to select the individual colors. I am not using days of the week, but the same method can be used for any field values.

Then my example should work too. Look at dynamicbackcolor in the help for another example. I woudl recomend using Nested IIFs instead of a method just because of the overhead involved.