Forum Discussion
Drop down box with different fonts, no change in the displaying cell
Dear Community, I have set up a table of cells with text in it. The first character in the cell uses the webdings font, the rest of the characters followed, are in regular fonts. I then use a dro...
Hello,
I don't think what you describe can be achieved without code. Data validation with a list using a range of cells takes the cell values and it ignores formatting.
Maybe you can display the Webdings symbol in a different cell and use a formula to populate that cell with the correct character, based on the value selected in the data validation cell. Then you can use conditional formatting to set the font color.