So I was complicating things by trying to modify the "Counting" macro, to change font colors as well.

As I understand you suggestion, I should leave the counting macro alone (as I have it now, I am calling it via the quick access tool bar after the template is populated), and use the color changing macro on entry and exit from each bookmark/dropdown.

May I ask why it should run on both entry and exit? It seems to me, the uninitiated, that running it on entry would cause issues or at least redundancy. That is, if run "on entry" the macro will change the font color per the initial value of the drop down "result", and on exit, it would change the font color per the value the user selects from the drop down list.

Would it not be sufficient to just run it on exit? I am not challenging your guidance/advice, just trying to fully understand the logic.

Thank you, very much.

Fergie