Custom formatting advice

Occasional Visitor

Good Morning.


I have come across a problem with custom formatting.

I have created checklists to use in our workplace. questions are simply answered with yes/no or N/A  using drop down menus. feedback is to change it, so when you type "1" it returns yes, "2" would return NO and "3" would return N/A ( or different word if needed).


I have used custom cell format to achieve yes or no with : [=1]"Yes";[=2]"No";   unfortunately, it does not work when I try to add third option. is this only allowed for two options? or I am doing something wrong?


1 Reply


Try this custom number format:




If the user enters anything else than 1 or 2, the cell will display N/A.