Allowed value in cell

[pmeghnathi]

How to excel cell allowed values only one carecter alphabet capital letters only C or B

 

[rpaulson]

Data validation, then list C,B

 

[SanjayGMusafir]

How to excel cell allowed values only one carecter alphabet capital letters only C or B

Data Validation - List - Manually Type C,B (in list)

 

[pmeghnathi]

Data Validation - List - Manually Type C,B (in list)

I try data validation list and i type cell small c cell accepted.
I want only latter C or D

 

[Jeffrey Mahoney]

 

[Cubist]

Try: Data Validation -> Allow -> Custom.

=OR(EXACT(A1,"C"),EXACT(A1,"B"))

 

[SanjayGMusafir]

I try data validation list and i type cell small c cell accepted.
I want only latter C or D

Check this -

When I enter using wrong capitalization -

 

[pmeghnathi]

Check this -

View attachment 110577

When I enter using wrong capitalization -

View attachment 110578

Thanks