Thanks for your reply.

I somewhat understand what you have done. What I don't get is the mechanics of how the cells in A5:A16 get the appropriate colors assigned. Can you please let me know how this step is done?

Thank you.