Data Validation : Allow only "X" or blank

[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

 

[Arvi Laanemets]

Hi

Data.Validation.List
Enter "X" into source value field

 

[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

 

[khanna_m]

Thanks a lot.. it worked....