Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown
- by adolf garlic
I have an Excel sheet that I'm using to keep track of the status of certain things.
I want to have a column which consists of cells containing a repeated drop down that allows you to select (as background)
red
amber
green
unknown
I don't want any text in this cell, I just want a coloured block.
Is this possible?
I've tried playing around with data-validation-list (based on range containing all of said colours but to no avail)