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 ...

It's turned on, but you'll expand a drop-down list in the left sidebar to see it. It's best if you customize the layout so that it only displays the Mail, Chat, and Meet tabs.