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

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

"aetzkin" wrote:

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

Try this:

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

Does that help?

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

XL2002, WinXP-Pro


"aetzkin" wrote:

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