How do I color code a drop down list in Excel 2000?

G

Guest

I need to create a drop down list in excel that is color coded, ie, drop down
is number 1-10, with number 1-3 being red, 4-6 yellow, etc. How do I do this?
 
J

jeff

Hi,

I don't think you can color your list inside the dropdown.
You could color the linked cell with conditional
formatting, but you'll only have 3 color selections.


jeff
 
F

Frank Kabel

Hi
not possible

--
Regards
Frank Kabel
Frankfurt, Germany

mn_bkd said:
I need to create a drop down list in excel that is color coded, ie, drop down
is number 1-10, with number 1-3 being red, 4-6 yellow, etc. How do I
Click to expand...
do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use color coded data on a drop down validated list 1
cell color from drop down list 2
Filtered drop down list 2
Select drop down menu option using libre-calc macro 0
Drop Down List 3
how do I use color in drop down list in Excel 1
Creating drop down lists with multiple options? 4
Drop Down List 2

Top