Drop down list (color)

Originally Posted by jimz97

I looking a way to create a drop down list value with label in color. For example, value A for Red, Value B for Yellow, Value C for Green and so on. I only manage to do this by using the formatting with condition but it only allow me up to 3 value. Do you guys know how to solve this problem?

Found some solution that need VBA script but I am not good in programming. Any one can help me?

see the link below
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm