Colour

%3CLINGO-SUB%20id%3D%22lingo-sub-1787524%22%20slang%3D%22en-US%22%3EColour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787524%22%20slang%3D%22en-US%22%3EI%20would%20like%20to%20use%20colours%20for%20a%20drop%20down%20list.%20Is%20it%20possible%3F%20And%20if%20it%20is%20will%20the%20text%20in%20my%20original%20cell%20will%20stay%20if%20I%20colour%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1787524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787668%22%20slang%3D%22en-US%22%3ERe%3A%20Colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834869%22%20target%3D%22_blank%22%3E%40VRJRDN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EPlease%20check%20this%20link%2C%20will%20help%20you%20to%20solve%20the%20issue.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F1513202%2Fexcel-colouring-items-in-dropdown-list%2F1514376%231514376%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EApply%20color%20on%20items%2Fdata%20in%20drop%20down%20list.%20%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E**%20%3CFONT%20size%3D%222%22%20color%3D%22%230000FF%22%3EIf%20my%20post%20solves%20the%20issue%20then%20please%20mark%20it%20as%20Best%20solution%20as%20well%20like.%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I would like to use colours for a drop down list. Is it possible? And if it is will the text in my original cell will stay if I colour it?
2 Replies

@VRJRDN 

 

Please check this link, will help you to solve the issue.

 

Apply color on items/data in drop down list.  

 

 

 

 

** If my post solves the issue then please mark it as Best solution as well like.

@VRJRDN 

 

Here is an example file with colors and a drop down menu.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.