View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Format cell to accept only specific character-reject 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.