Special symbols/font in data validation

[mikeymay]

I have a specialist font for garment care symbols (Medium iron, do no wash, dry clean only, etc) which I need to show in a drop down.

The font I have installed shows the actual symbols in the cell but when the drop down is clicked it shows the alphanumeric characters (t, f, x ,!, etc).

Is there anyway to show the actual symbols in the drop-down?


TIA

 

[Akuini]

I don’t think you can do that with data validation, you may want to use a combobox instead.
You can set up a combobox that act like data validation & set it up to be dynamically visible (it will show up only when you enter a certain cells).