Data Validation : Allow only "X" or blank

K

khanna_m

Hi,

I'm preparing a sheet for attendance.

The requirement is that the user should be able to enter only "X" o
leave blank in the cell meant for that day's attendance.

I dont want to use list or input box to make the entries fast an
easy.. Users should write only

1 2 3 4 5 6 7 8 9 .....
X X X B X X B B X .....

(B = blank)

This way there are 31 * 12 cells for the whole year that needs to b
validated

The data validation for character does not allow to validate agains
values. Only length of text can be validated. I want that only X o
blank should be allowed..

Please help. Thanks a lot
 
D

Debra Dalgleish

In the data validation dialog box, choose to Allow List
In the Source box, type an X
Remove the check mark from 'In-cell dropdown'
Click OK

This will be case sensitive, and only a capital X will be accepted
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation based on three conditions 6
How do I use a conditional (IF) statement in Data Validation? 3
Access Userform validation rule wont work - Please help 0
Validation problem. 3
Data Validation based on other cells 3
V-lookup and Countif 2
Data Validation List (conditional) 2
custom data validation on cells with data validation values 2

Top