>Nested IIF()'s worked great. They are tricky to code with over two or three colors - you have to pay attention to the parenthesis.

Yeah, tell me about it. I wrote an ICase() UDF once, which I used for DynaminBackColors, its syntax was like:

Icase(expression1, return1, expression2, return2, expression3, return3...)

and it cleaned it up quite a bit. I'm glad you got it working though.