Gmayor's macro works beautifully. Now I am wondering why I can't change the font color on the dropdown selection based on its value.

I tried oFF.Result.font.color = vbRed, for example, but got a compile time error of "Invalid Qualifier". Presumably because the way the code is getting to the dropdown value I cannot use the "." notation to manipulate it. Is there a decent text/reference that explains (with examples) how to properly set up and manipulate the font attributes for the dropdown value?

Thanks much,

Fergie