Drop Down List Or Data Validation List To Insert Text In To Cell Range

[regc]

Greetings

I am setting up a new workbook and would like some help getting started.I used 2 control as they give larger size fonts then D.V Lists.I have posted a sheet which explains where I need help

Regards

Reg

[alansidman]

See attached. Used Data Validation. Seems the simplest method and adjusted the font size for the particular row.

[regc]

depending on the finished worksheet I find that sometime the data validation list becomes almost unreadable due to size of letters.You sample is good though.If I require a control form button such as a combobox will that work as well in the same way as your sample?
Also I need to sometimes have the same words for the different list colors in data validation list.I get an error with my formula.Please see
Regards
RegC

[Ingolf]

Hi,

In C15 try this: =IF($C$9="Blue Water";"Chill";IF($C$9="red water";"chill";""))

[regc]

Thanks