Is it possible to create a drop down in Excel with no text just color options to fill a cell?

user_14895985 0
Viewed 621

As the title says, I would like to create a dropdown with no text only color options to fill the cell. I'd like to give only a few specific options to the user, for convenience and simplicity.

It would also facilitate my VBA coding because I'm using cells().Interior.ColorIndex to identify the color and do certain tasks depending on the color chosen. So, I suppose I'm restricted by the 56 colors in the index color pallet of Excel.

Is this possible?

vba excel
1 Answers

Well, I didn't accomplish what I wanted 100% but with the help of Stackoverflow developers I got to a pretty cool result which works perfectly for what I wanted and it could probably be useful for someone else.

So what I did was a drop down menu with the colour names and a Conditiontal Formatting which converts the text and fill of the cell to the specific colour. I downsized the font size to 1, so I can use them as small rectangles.

enter image description here

user_148959850
Related