Create Drop Down List in Excel with Color

Original Question:-

How to add drop down list with color in Microsoft Excel?
 
So I figured out how to create a dropdown menu in Excel. I would like to color code the menu options. Here is my menu list: Green, Red, Yellow, and Blue. I have them in the dropdown menu and I would like to put their associated name with the appropriate color background rather than just using the white cell with black letters. Green would have a green cell color, Red would have a red cell color, and so on and so forth.
 
I made a list:
List (Color needed)
Extreme (Red)
High (Orange)
Moderate (Green)
Low (Yellow)
Then I went to data validation and made the list in a dropdown menu.

What I would like to do Is that I when I choose option Extreme from the dropdown menu I created I would like it to have a Red color either text or cell color. But I would like the color to change depending on option I pick from the list.
 
image 1

 

To add color in drop down list with color we will make a list of color in Excel follow below given steps:-

  • Select any cell in the sheet.
  • Go To Data tab.
  • Data Tools > Data Validation.

image 2

 

  • In the Settings tab > List > Source ($A$2:$A$4)

image 3

 

  • Click on OK.

 
How to add drop down list with color in Excel?

To create dropdown list in Excel with colors, follow below given steps:-

  • Select the dropdown list.
  • Go to Conditional Formatting > New Rule.

image 4

 

  • Click on New Rule > Format only cells that contain > Specific Text > Containing > Blue.

image 5

 

  • Click on Format > Fill tab > select the blue color

image 6

 

  • Click on OK.
  • Repeat the same steps to add the Red and Green color.

 

image 7

 

image 8

 

When we select any color name from the dropdown list, cell color will get changed.

 

image 9

 

This is the way to adding color to a drop down box or color cell drop down in Microsoft Excel.

 

image 48
 

How to edit a drop down list in Excel?

How to delete drop down list?

How to create dependent drop down list?

How to create multiple dropdown List without repetition using named ranges?

How to create drop down list?

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube