• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

I wish to have in my spreadsheet a drop down list of three different colours only...GREEN, RED and GREY


I have a Zoho spreadsheet (Macros possible) online which I am trying to implement the following functionality:

I have a list of items in column A and I want to assign them a colour code in column C.

So, I want the user to be able to click the corresponding row in Column C and be presented with a drop down of three colours (RED, GREEN or GREY).

How do I do this?


1 Solution
I added Validation in Col C to give you 3 choices Red, Green, Grey

and Added Conditional formatting in Col C so that if

Red is choosen then it color the cell in Red etc.. for the rest.

check it out
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now