Custom formatting advice

[Adamsibilski]

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?

await

[#2]

@Adamsibilski 

Try this custom number format:

[=1]"Yes";[=2]"No";"N/A"

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

[#3]

@Hans Vogelaar 

IS it possible to make one that does this:

Enter:
1 is "Dismisssed"
2 is "In Progress"
3 is "Settlement"
4 is "Guilty"

[#4]

[=1]"Dismissed";[=2]"In Progress"
[=3]"Settlement";[=4]"Guilty"


I tried the above, but 3 and 4 dont work 1 and 2 do

[#5]

@Johnthegreen 

In sch a custom number format, you can use only two sections of the form

[=value]format

So instead of formatting the value itself, use a formula in another cell to display "Dismissed" etc.