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

LeonPrice
LeonPrice used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial