Let’s start from scratch. I’ll begin by creating a fresh dropdown list from a list of color options. If you’re not already sure how to add a drop-down list in Google Sheets, start with this ...

In the resulting popup, give your drop-down a name, an associated color, and add the necessary items to the list. Once you've finished, click Save and the new drop-down will be available for use ...

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.