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)
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.
To add color in drop down list with color we will make a list of color in Excel follow below given steps:-
How to add drop down list with color in Excel?
To create dropdown list in Excel with colors, follow below given steps:-
When we select any color name from the dropdown list, cell color will get changed.
This is the way to adding color to a drop down box or color cell drop down in Microsoft Excel.
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 firstname.lastname@example.org
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.