Hi Andrew,

>I believe that will only give him 2 color options Mike. Not the 3 colors he wants. The 'IIF' parts are the key. I'm nesting them so I can specify more than two colors than if I just used one 'IIF'.

Right-y-O. He said he got the whole row to change, and, thus, understood the nested IIF()s idea, he just needed to get the individual cells to change, so I figured I'd show him what I did. Thanks for the reminder though!