Drop down list - Display Yes/No but returns "tick"/"cross" symbols

[dmacmillan]

Hello All,

Seeking assistance with drop down lists with symbols.

I require a drop down list that displays Yes/No but returns a "tick" or "cross".

Is there Custom text formatting equivalent of [=1]"Yes";[=0]"No" using Wingdings to present symbols. For example, [=P]"Yes";[=O]"No" .... I cannot get this to work.

Many thanks,
David

 

[dmacmillan]

You can do it with CF. First set the cell's regular number format to:
;;;"P"
which will handle the Yes values. Then add a conditional format rule to set the number format to:
;;;"O"
when its value is No. Then change the font, and job done.

Elegant in its simplicity.
Thank you RoryA

Kind regards,
David

 

[RoryA]

Glad we could help.