I wish to have in my spreadsheet a drop down list of three different colours only...GREEN, RED and GREY
Posted on 2014-02-25
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?