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

Hi

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?


Thanks



Leon
LeonPriceAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
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
gowflow
Colors.xlsx
0
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.

All Courses

From novice to tech pro — start learning today.