Format cell to accept only specific character-reject others

A

aetzkin

I am trying to format a cell so that it will only accept the characters H or
F and reject all others.
 
E

Elkar

Select the cell, then select "Validation" from the "Data" menu. Select
"Custom", then enter the following formula:

=or(A1="H",A1="F")

Replace A1 with whatever cell you are using.

HTH,
Elkar
 
R

Ron Coderre

Try this:

Select the impacted cells
Data>Data Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top